Over the long weekend, I upgraded our database from SQL anywhere 10 to SQL/A 16. It is hosted on WIndows 2008/R2, hosted on VMWare. I did the upgrade 'properly' in that I did a db unload/load to create the .db file from scratch. In the test environment, everything seemed to work just fine. In production and under load, everything is working, but the server instance is using huge amounts of CPU. I'm looking for hints to figure out where the problem is. What I've done so far:
Start-up parameters are:
-x tcpip -c 3g -ch 10g -ti 120 -tl 600 -o C:\DATABASE\LOGS\Sybase.TXT -os 2m -dt d:\temp\Sybase -n DBSERVER2 D:\DATABASE\MYDATABASE.db -n DBNAME2
Any insight appreciated.
asked 07 Jul '14, 16:15