Hi I have a Sybase 12.5.4 with all data row locking tables and have a very big problem. Sometimes my tables are locked for inserts, updates...

rsm

11-27-2012 03:30 PM
rsm

We are about to move from SAN based spinning disk to SAM based SSD. Our hardware architect would also like us to reduce the number of drives we use....

Xerxses

10-28-2012 09:00 PM
Xerxses

Hi, Question: When I run the query in stored procedure, it takes 7 minutes When I run the query in ASE open window, it takes 10 seconds What is...

guru4dw@gmail.com

10-02-2012 06:02 PM
Milo Minderbinder

Hi all, First post here... I'm currently documenting the new SAP tool DBA Cockpit, which is the monitoring and administration tool for ASE in the...

tonyfitzer7@gmail.com

07-05-2012 08:42 AM
tonyfitzer7@gmail.com

----------------------------------------------------------- SCHEMA ----------------------------------------------------------- CREATE TABLE...

Paul

04-06-2012 10:07 AM
Paul

Doesn't anymore has experience on tuning the "optimizer level"? It seems like a new feature since ASE 15.0.3 ESD#2, performance related optimizer...

Romeo

02-02-2012 08:20 AM
Romeo

Dear group, my question, in short, is this: Does COMMIT read log pages? I think ASE doesn't do that; that is, for a COMMIT it only flushes URL to...

Mariano Corral

01-09-2012 09:53 PM
Antony

Hi We are experiencing an unusual problem with our system that is proving difficult to track down. The system is a 3 tier app, uses a custom JDBC...

timwood

11-02-2011 04:58 PM
timwood

Hi, į would like to know how to configure Sybase Central to monitor Sybase ASE for performance issues. Can it be configured to do that? Also how...

omaigad

10-30-2011 05:00 PM
Antony

It was suggested that I enable the Resource Governor to prevent any of our adhoc power users from bringing the server to it's knees. If I'm reading...

Richard

07-19-2011 03:42 PM
Richard

is it possible for a single thread insert/update to APL table with only nonclustered index to trigger deadlock? if not, what else could be possible...

Joshua

06-21-2011 01:43 AM
Joshua

Adaptive Server Enterprise/12.5.3/EBF 12331 ESD#1/P/Sun_svr4/OS 5.8/ ase1253/1900/64-bit/FBO/Tue Jan 25 08:52:58 2005 I was monitoring a process...

Taylor

06-14-2011 09:12 AM
Taylor

When I use sp_metrics to drop roughly 180k metrics rows from a db (on ASE 15.5), it's running out of locks on our server (300k limit). Is there...

bslade

05-03-2011 04:27 PM
bslade

Hi there all! Time for a new release of AseMon - the ASE Performance Monitoring GUI (www.asemon.se) If you haven't tried it yet, please do so, and...

Göran Schwarz

05-03-2011 04:23 PM
bslade

Hey folks. I am re-visiting some very old stored procs. One in particular has been giving me problems. Joins are my weak point, and I hope someone...

Nowell

03-03-2011 11:11 AM
bslade

Hello we have a production databaser server running on Linux red VMWare had and installed sybase 15.5 the performance is slow while ether dumping,...

Ana

03-02-2011 07:24 PM
Ana

i'm trying to figure out how to invoke upsert bulk through sql statement. i understand that sybase etl, owb, and other etl tools offer this as part...

dc

02-14-2011 03:43 PM
bslade

Hi, Wish you happy new year!! The question is about sp_monitorconfig result. 1> sp_monitorconfig "all" 2> go Usage information at date and time:...

Minch

01-01-2011 12:42 AM
Minch

maghac

12-02-2010 11:43 AM
maghac

dicomal

11-16-2010 01:34 PM
dicomal

Hi, I am preparing a script to run reorg rebuild for indexes on a production environment. There are many many tables, and I am willing to somehow...

Tahir

10-05-2010 05:06 AM
Tahir

Hello, Just a curious question for which I haven't got a clear answer. If I change the optimization goal for a session, are the subsequently...

Amal

09-07-2010 12:13 AM
Kristian

After reading thru the docs for tempdb, tempdb write optimization, and the cache config option "HK ignore cache" and checkpoints, I have...

Robert Densmore

09-03-2010 03:23 PM
Robert Densmore

My name is David Morris. I am a recruiter for a company named Doozer Software (www.doozer.com) in Birmingham Alabama. Doozer Software specializes in...

DoozerDave

07-16-2010 01:59 PM
DoozerDave

Hello, I've got following problem on: Adaptive Server Enterprise/15.0.3/EBF 16744 ESD#2 There is a query that executes very slowly...

Darek

06-07-2010 03:58 AM
Darek

Greetings, I am getting a strange error while execution of an sp. Here is the basic flow. Procedure P1--> 1)Create #summary 2)---some business...

test

05-20-2010 12:55 PM
test

Hello, we are currently evaluating xml services on sybase 15.0.2 and 12.5.1. Accessing data is done via ODBC on a table containing 1000+...

tbl

03-23-2010 07:46 AM
tbl

I came across the interesting issue on ASE Server.(Still not sure, need to check with you guys) Suppose in our prod env, we have cross database...

Anva

02-16-2010 10:02 AM
Anva

Hi, We have many large tables 50milions+ records with at least 10+ data partitions (round robin) on all of them. Because of lot of data activities...

KS

02-03-2010 04:33 PM
KS

Each time I execute the sp takes different time to finish: Miliscd 86 20 16 16 26 10 16 16

M.A.Garcia

01-28-2010 09:48 AM
Mark A. Parsons

Hi, i've looked in the ASE doc, but i can't find an answer to my question. When a 'dump database' command is given, what is exactly dumped? Lets...

Pieter Coene

01-25-2010 10:26 AM
Pieter Coene

hi, is there a way in ASE 15.0.3 to have no transaction log on specific table? Now we create the table in tempdb, but i'd rather have the table in...

Pieter Coene

01-21-2010 02:54 AM
Kristian

Hi, I have a sp in database A. And the sp will access tables in database A. Now somehow the sp will be moved to database B and the performance goes...

Taylor

01-20-2010 12:41 PM
Mark A. Parsons

hi ! got a funny behavior between 2 servs, which are very similar afaik. Same version, same statistics (both anyway rebuilt), same table/indexes,...

msthandi

01-18-2010 07:12 PM
Wanderer

I have a select statement inside a proc, when the proc is call aleatory takes a range from 0,3ms to 100ms,300ms and 500ms how can i find what is...

Marco

01-12-2010 03:25 AM
Marco

Hi, is there a way to detect an "Unlogged operation" so we can initiate a full dump automaticly? greetz Pieter

Pieter Coene

01-07-2010 04:26 AM
Pieter Coene

I still do the following to obtain the results needed for a full outer join: SELECT * FROM Tab1 LEFT OUTER JOIN tab2 ON A=B UNION SELECT *

Tartampion

12-30-2009 06:38 AM
mpeppler@peppler.org [Team Sybase]

We have the following situation: while delete insert(DML) is going on on our tables, we bcp out data from them. Unfortuantely, the bcp reads the...

tartampion

12-28-2009 03:23 PM
Tartampion

Hi, ULC Flushes to Xact Log per sec per xact count % of total ------------------------- ------------ ------------ ...

Taylor

12-25-2009 08:16 PM
SpeedyIQ

Hi I am doing a simple test, Updating all rows in tbl1 which has 1 million rows. 1) When no index apf=0 total=18001), physical reads: (regular=8...

update query

12-16-2009 10:24 AM
update query

I have "transpetrol" table in "tptrldb" database(500+ million rows) I have "transpetrol" view in "ptrldb" database view is: select * from...

Steve

12-11-2009 10:37 PM
Cory Sane [TeamSybase]

A series of sp_sysmon reports leads me to believe that 60% of my buffer grabs are 16k, 10% are 4k, and 30% are 2k. What should by buffer pool...

ahood

12-11-2009 09:22 AM
Mariano Corral

Hi all, I have a table "transpetrol" with 500 + million rows. lockscheme is allpages. ASE verions is : Adaptive Server Enterprise/12.5.0.3/EBF 10976...

Steve

12-07-2009 03:19 PM
Steve

I'm on ASE 15.0.2 ESD#6. Suppose I create a temporary table, and then I call a stored procedure which uses that temporary table. Then, suppose...

John Flynn

12-07-2009 09:11 AM
John Flynn

Indeed -- and not just for tempdb, but also you procedure cache will be used by the sorting operations. For large tables, you may run out of iit...

kdb

12-02-2009 08:25 AM
kdb

Taylor

12-01-2009 02:59 AM
Taylor

Hello everybody, What I have recently experienced on a system is, keeping statement cache too high may cause a performance drop; probably because...

ozgur.kara

11-25-2009 08:15 AM
John McVicker

Hi Guys, Does anybody knows how to configure a sybase's user to allow a sitescope performance monitor application can read sysbase´s monitor...

Joseju

11-21-2009 08:30 PM
Mark A. Parsons

Have you captured the query plan when it went bad? Can you post it? ALso - do you have options enabled as Mark said - the statement cache and...

John McVicker

11-20-2009 12:20 PM
John McVicker

Team, my coworkers have written queries in the following for: insert TableB select isnull(colA, "-1") from TableA The monProcessObject shows the...

Cory Sane [TeamSybase]

11-20-2009 12:14 PM
John McVicker