Really quick tip:
A client, after an ASE 15 upgrade (ESD #2), was experiencing significant increase in Rep Server stable queue length.
The latency vanished after enabling literal autoparameterization.
Subscribe to:
Post Comments (Atom)
About Me
- Jeff Garbus
- I've been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2, and Sybase ASE since release 4.0.1. Since then, I've worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses. I have been working on large-scale systems for most of that time, having tuned a 100-gig/week throughput application on MS SQL Server 6, and created one of the first ASE data warehouses. My background includes work experience from PC's to Mainframes and back again, in all aspects of IT, from developer, to DBA Manager, to IT Executive. My specialty is performance and tuning with a special emphasis on large-scale projects with very large databases. I am very well known in the industry, having spoken at user conferences and user groups for many years, written articles and columns for many magazines nationally and internationally, as well as having written over a dozen books.
Hi,I have been working as Sybase ASE DBA for the past 4 years in one of the major investment banks.I also look into replication server issues.we are planning to upgrade ASE as well as repserver.
ReplyDeleteThis is one of the nice blogs i have even come across on Sybase.Get going.
Also i found http://www.sybaseteam.com helpful for sybase discussions.