I wann't to move my sql server onto virtualized platform (Vsphere, esxi 4.1). Here is my plan on how would I install it:
- Vm with 3 disk's. C: for windows and sql binaries, D: for sql data, E: for logs
- All disk on different datastores
- Disks D: and E: are independen't so snapshoot's won't effect them
- Root folder for every instance is on default path (C:\program files...)
- data and log folder is moved onto D: and E: disk
Ram and cpu cores will be added as needed.
Is there a way to monitor and graph CPU, RAM usage and dik I/O for let's say 24h to get some info about load on the server (with built-in windows tools).
Will this work fine and do you have any special tips&trciks ? Best regards, Primoz.
EDIT
I tried simple test setup with just two disk C: for installation and D: for data and logs and with 2 vCPU's and 6GB of ram. With my test suite I have push the cpu usage to 90%+ and ram usage to 98%. So I'm guessing that this means that disk is fast enough and that I'm limited by CPU and RAM ?