We moved a SQL Anywhere 12 database from a dedicated windows 2003 SP2 server to a new virtual machine running windows 2012 R2 SP1 server.
Windows 2003 server specs: 6134 MB memory 8 cores SQL Anywhere 12.0.1 build 3910
Windows 2012 server specs: 16384 MB memory 8 cores SQL Anywhere 12.0.1 build 4403
From another database we use proxy tables to this database to fill the database. On the windows 2003 server this takes 2338 seconds On the new windows 2012 server this takes 3867 seconds
I would expect that it would run faster on the new machine or at least at the same speed.
It must be something in the setup of the windows 2012 server. Does anyone have a clue where I should look?
What is your license ? If you have a chip license and configured the vm with cpu instead cores than your affinity ist on only one cpu. Go to taskmanager -> rightklick on dbsrv12.exe and select Set affinity. The you see on how many cores the db is running.
answered 03 Nov '16, 03:27