Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

dsi performance

2 posts in General Discussion Last posting was on 2012-12-10 07:23:28.0Z
vtpcnk Posted on 2012-12-10 06:57:56.0Z
Sender: 2ccd.50c5863b.1804289383@sybase.com
From: vtpcnk
Newsgroups: sybase.public.rep-server
Subject: dsi performance
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50c587f4.2d27.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 9 Dec 2012 22:57:56 -0800
X-Trace: forums-1-dub 1355122676 172.20.134.41 (9 Dec 2012 22:57:56 -0800)
X-Original-Trace: 9 Dec 2012 22:57:56 -0800, 172.20.134.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9284
Article PK: 1158202

if for whatever reason, i find the data backed up in the
replication queues and the replication to the replicate
server is slow, then to speeden things up can i increase
values for :

dsi_cmd_batch_size and dsi_max_xacts_in_group

(i think dsi_max_xacts_in_group has to be less than or equal
to dsi_xact_group_size).

and to accomodate the increase in the values for the above
parameters, should also sqt_max_cache_size (or
dsi_sqt_max_size if individually configured) be
proportionally increased?

and is 'admin status,mem_in_use' a credible way to measure
how much memory is currently being used and can the
available memory (for reconfiguration as above) be deduced
by subtracting this figure from the memory_limit parameter?

appreciate the insights.


vtpcnk Posted on 2012-12-10 07:23:28.0Z
Sender: 2e02.50c58ba8.1804289383@sybase.com
From: vtpcnk
Newsgroups: sybase.public.rep-server
Subject: Re: dsi performance
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50c58df0.2e80.1681692777@sybase.com>
References: <50c587f4.2d27.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 9 Dec 2012 23:23:28 -0800
X-Trace: forums-1-dub 1355124208 172.20.134.41 (9 Dec 2012 23:23:28 -0800)
X-Original-Trace: 9 Dec 2012 23:23:28 -0800, 172.20.134.41
Lines: 13
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9285
Article PK: 1158203

i just saw the earlier thread from a week or so back where
somebody had raised similar questions about improving dsi
performance.

in my case, let us just say there was suddenly a huge
transaction in the primary which caused like 5 gb worth of
transactions in the queues. so i just want this chunk of
data to be processed fast - by tweaking whatever parameter
on the rep server. then once the queue has drained, i
probably will put the tweaked parameters back to their
original values.

thanks in advance for the feedback.