SQL Anywhere 10 really really slow - does it have the capability corp & 30 sites?

[n***@hotmail.com]

Any ideas? We have a customer with 10 years of data and a 28 Gig Sybase SQL Anywhere database size now. We are now seeing slow downs like never before. There are probably 40 users along with replication running as well to 30 sites. I am just wondering if we have maxed out the SQL Anywhere capabilities. The customer even has solid state drives, tons of hard drive space and memory. The database cache looks fine as well and has never maxed out and when the number of users drops down to one or two users everything is just fine. Thoughts?

[p***@gmail.com]

Post by n***@hotmail.com
Any ideas? We have a customer with 10 years of data and a 28 Gig Sybase SQL Anywhere database size now. We are now seeing slow downs like never before. There are probably 40 users along with replication running as well to 30 sites. I am just wondering if we have maxed out the SQL Anywhere capabilities. The customer even has solid state drives, tons of hard drive space and memory. The database cache looks fine as well and has never maxed out and when the number of users drops down to one or two users everything is just fine. Thoughts?

I have been dealing with large Sybase Anywhere deployments for years from version 5 to 12. There is tons of possible problems and solutions. I would recommend that you determine if you are CPU ( per core or total? ) or Disk I/O limited. It also be a issue of either network bandwidth, latency, scheduling etc.

One other things to look for is index "histograms". Have you tried rebuilding the database? If it is histograms that require a fix apart from rebuild. Do you have enough workers assigned in DB engine? A deeper step would be to try profiling it looking when it so busy as to what it is spending time one...

is it perhaps "locking" issue.

There are very many variables, sorry I could not be of more help.