| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | -----------------------------------------------------------
SCHEMA
-----------------------------------------------------------
CREATE TABLE...
Paul
|
04-06-2012 10:07 AM
Paul  | 0 | 68 |
| | | 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 | 0 | 123 |
| | | 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 | 1 | 35 |
| | | 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 | 0 | 23 |
| | | 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 | 1 | 32 |
| | | 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 | 0 | 23 |
| | | 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 | 0 | 22 |
| | | 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 | 0 | 20 |
| | | 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 | 0 | 20 |
| | | 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 | 1 | 29 |
| | | 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 | 1 | 20 |
| | | 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 | 0 | 23 |
| | | 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 | 1 | 27 |
| | | 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 | 0 | 19 |
| | |
maghac
|
12-02-2010 11:43 AM
maghac | 3 | 22 |
| | |
dicomal
|
11-16-2010 01:34 PM
dicomal | 1 | 21 |
| | | 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 | 0 | 23 |
| | | 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 | 2 | 22 |
| | | 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 | 0 | 23 |
| | | 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 | 0 | 31 |
 | | 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 | 0 | 1,148 |
| | | 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 | 0 | 279 |
| | | 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 | 0 | 395 |
| | | 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 | 4 | 490 |
| | | 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 | 0 | 379 |
| | | 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 | 5 | 374 |
| | | 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 | 2 | 260 |
| | | 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 | 6 | 363 |
| | | 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 | 5 | 325 |
| | | 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 | 4 | 274 |
| | | 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 | 2 | 260 |
| | | 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 | 2 | 301 |
| | | 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] | 1 | 318 |
| | | 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 | 13 | 435 |
| | | Hi,
ULC Flushes to Xact Log per sec per xact count %
of total
------------------------- ------------ ------------ ...
Taylor
|
12-25-2009 08:16 PM
SpeedyIQ | 2 | 328 |
| | | 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 | 2 | 243 |
| | | 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] | 1 | 243 |
| | | 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 | 1 | 284 |
| | | 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 | 3 | 234 |
| | | 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 | 2 | 242 |
| | | 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 | 19 | 472 |
| | |
Taylor
|
12-01-2009 02:59 AM
Taylor | 7 | 306 |
| | | 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 | 3 | 237 |
| | | 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 | 1 | 286 |
| | | 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 | 7 | 261 |
| | | 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 | 2 | 305 |
| | | This document does not have all that create problems.
I conclude. No more comments.
"Carl Kayser" <kayser_c (AT) bls (DOT) gov> wrote
ahood
|
11-19-2009 09:01 PM
Vickey | 7 | 556 |
| | | Hello,
I am running a relatively large benchmark workload (25,000 SQLs per second),
on Intel Nehalem/RHEL 5.4 servers.
I have optimized the...
Jean Dagenais
|
11-12-2009 02:20 PM
Stefan Karlsson | 5 | 448 |
| | | Hi, all
I recently landed a contract to address some performance
issues my client is having on an ASE 12.5.3 server on
Solaris. The first issue I...
Guy Gallagher
|
11-11-2009 03:56 PM
John McVicker | 4 | 257 |
| | | Thanks for the info. BTW, you posted what appears to be a parallel access
plan (a 3 threaded scan on table a) which is different from what...
John McVicker
|
11-11-2009 10:10 AM
Sherlock, Kevin [TeamSybase] | 6 | 367 |
