SQL Server with Mr. Denny

Jun 25 2009   9:00AM GMT

Setting VMware memory settings to improve SQL Server Performance

Denny Cherry Denny Cherry Profile: Denny Cherry

Tags:

There is a VMware setting which you can set which should give you a small but noticeable performance improvement in SQL Server performance when that SQL Server is running within a VMware Virtual Machine.

This setting is the Large Pages setting.  This will allow the SQL Server to allocate memory from the host in 2 Meg chunks instead of 4k chunks.  This has been shown to provide up to a 6% performance improvement in performance, however your mileage may very.

This setting can be found by editing the Hosts Advanced Settings on the Configuration tab.  The setting is Mem.AllocGuestLargePage.

Denny

2  Comments on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.
  • Jrm1010
    hola necesito saver como intalo configruarcion settings para desbloquiar un dicdor telefonico que lo tengo bloquiado
    0 pointsBadges:
    report
  • Denny Cherry
    Sorry, but can you repost this in English? BabbelFish can't translate most of it.
    67,485 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: