If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Sybase > ianywhere slow now on VMWARE ESX

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-28-09, 13:29
claytonids claytonids is offline
Registered User
 
Join Date: Apr 2004
Posts: 6
ianywhere slow now on VMWARE ESX

Since a customer moved the database to a virutal machine Vmware, windows 2000 using sybase ianywhere 8.0.3:5002 the database is now slow. Major slow. Not only our applications but what took only a few minutes for even sybase dbbackup.exe across the network now takes for ever. Our applications of course are also affected. Any ideas. They say CPU says only 3% being used, they have 1G of memory allocated and 1Gbit ethernet. How to we prove the db IO as well being slow? I am going to move the DB DSN as well for a test to another location physical machine.
Reply With Quote
  #2 (permalink)  
Old 06-28-09, 21:26
Lerac Lerac is offline
Registered User
 
Join Date: Jun 2009
Location: South Africa
Posts: 33
Any form of database server is not really a good candidate to virtualize. Databases are typically IO intensive applications without the need to hog CPU. You should also look for swapping or paging activity, to verify that enough memory is available to the application.

Enable disk performance monitoring using "diskperf -Y" on both the physical and virtual machines, and then compare the average throughput for the same type of queries against the servers. You would probably need to reboot them for this.
The fact that the CPU is only at 3% does not really matter, you need to look at the disk stats and check that memory is sufficient.

If you are using iSCSI devices, slow network responses could be the culprit, or the fact that the device or the VM is NOT communicating at full duplex. Verify that the NICs are set for full duplex, and are in fact using full duplex

I would also suggest maybe comparing startup parameters on the old and new systems, to ensure that the VM config and the physical server configs are at least similar in terms of memory allocated for caches and temp usage.
Reply With Quote
  #3 (permalink)  
Old 06-29-09, 10:39
claytonids claytonids is offline
Registered User
 
Join Date: Apr 2004
Posts: 6
I will have them give that a try. To get them to move back or stub this out may be like pulling a tooth. thank you again. I still would like other suggestions if at all possible.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On