Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DBA in the making
Aged Yak Warrior
638 Posts |
 Posted - 2011-07-28 : 06:09:38
|
| I'm doing some work for a charity, and they're looking at virtualizing their production database as the hardware is getting pretty old. I'm wondering if anyone here has any experience with this sort of thing, and could possible offer some dos and don'ts. The database and the application it feeds are both very poorly written, and this puts a huge IO strain on the existing server.------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-07-28 : 11:48:48
|
| -- Make sure not to overprovision resources if other clients share the host VM.-- Do not allow the VM tools (forget what it's called right now) to dynamically move or resize drives. This will crash SQL Server.-- test. test. test. |
 |
|
|
opowell
Starting Member
12 Posts |
Posted - 2011-08-03 : 16:03:41
|
there are 4 things that I have my VMWare team do with every instance of SQL Server. 1. create a seperate drive for the Swap space. and leave 3Gig on the C: drive for our friend Dr. Watson. and then 2* memory for a swap drive2. Seperate Drives for Data files, log files, and indexing.Exmaple: E:\MSSQL.1\MSSQL\Data\databsename\*.mdf F:\MSSQL.1\MSSQL\TransactionLogs\database name\*.ldf G:\MSSQL.1\MSSQL\Indexes\Databasename\*.ndf3. set the memory to make sure it does does not step on the servers memory requests.4. Go 64BitAbove all make sure the VMWARE Drivers are currentAlso Noticed better preformance on VMWARE ESX 4.1  |
|
|
|
manju3606
Yak Posting Veteran
78 Posts |
Posted - 2011-08-04 : 08:15:31
|
| Enable awe in your sql-server and what opowell is posted thats also goodManju |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-04 : 11:01:49
|
quote:
Originally posted by manju3606
Enable awe in your sql-server and what opowell is posted thats also goodManju
Only if it's 32 bit.Opowell's advice has nothing to to with VM environment. That applies to all installations. |
|
|
|
|
|
|
SQL Server on VMWare