SQL 2005 performance on WMware

THonny_Birch · 2008-12-17

Hi
Does any one have experience with running SQL 2005 on WMware?

My problem is DynamicsNAV is running slow, the database is installed on SQL 2005 on WMware and I don’t know anything of how to increase performance on the SQL server in this environment.

It takes the NAV database is five times longer to do a job on the SQL on WMware that it dose on my laptop in a native database.

Can anyone help me finding someone that can support me on this?

Regards Thonny Birch

David_Singleton · 2008-12-17

Navision can run very well on VMware with SQL. Its a great environment.

But don't expect to just "Run Install" and hope for the best. It needs to be very carefully installed and managed. just wrong incorrect settings with drives CPUs or RAM and the whole thing can fall to pieces. If you don't have experience, then best is to get in someone that has experience.

Marije_Brummel · 2008-12-17

David is correct, and having performance issues with NAV on VMWare (ESX) add's another dimension to your performance project.

We work very closely together with a VM Ware expert and have invested heavily in this technology ourselves. In fact our own performance Lab run's on VM Ware.

Please read my blog about this

http://dynamicsuser.net/blogs/mark_brummel/default.aspx

Do you have access to the infrastructure client? If so, then have a look at the performance graphs. Are there more machines running on the same box? Do they have the same problems?

Going to Microsoft is useless since they do net even support Dynamics on Hyper-v, let alone VM Ware.

Don't give up, we have customers with very large systems running perfectly on VMWare.

Good luck

THonny_Birch · 2008-12-18

Thanks

I will keep on working on this.

Thonny

SQL 2005 performance on WMware

Comments

Categories