Database Server VM tuning tips

[vAdmin]

Hi All,

I'm running SQL Server 2005 database query test using custom Java Application in Windows Server 2003 x64 VM

to gain better performance I have set like the following:

1. adding more vCPU

2. set the CPU/MMU Virtualization into "Use Intel VT-x for MMU Virtualization"

FYI: the ESXi host is running ESXi4u1 on top of Intel Xeon E 5420 @ 2.5 GHz

I also read the whitepapers from: http://www.vmware.com/solutions/business-critical-apps/sql/

but somehow the result is slightly lower than it was before i set options 1 and 2 ?

can anyone share your experience here please in optimizing SQL Server 2005 VM ?

Thanks,

AWT

[J1mbo]

How many vCPU are we talking? Generally more than 2 can cause problems.

Please award points to any useful answer.

[LucasAlbers]

Are you talking about tuning a java application + sql server, or just sql server?

For java checkout the java best practices doc.

[vAdmin]

Hi Lucas,

Hm.. not sure perhaps both, in this case the memory I assigned is just 2 GB, would it be worthwhile to try for "Large page" settings changes in the secpol.msc ?

Kind Regards,

AWT

[DSTAVERT]

I found this quite helpful http://communities.vmware.com/docs/DOC-8964

[vAdmin]

Thanks for the reply, next step is to increase the RAM into 4 GB and then performing the large page size config. from secpol.msc

Kind Regards,

AWT