First thanks for weighing in on this.... I support a department whose deployment of several department size SQL 2000 systems needed overhauling. I have recommended virtualizing their SQL because:
1. this is a department level database that has at best moderate use
2. It is currently and comfortably deployed on servers with 2GB of ram and processors of no more than 2 at 500 mhgz each
3. local storage for raid 5 on single volume with OS
AND becuase my virtualized environment will be:
1. On a 28 disk SAN that virtualizes all the disks into one raid group for performance (also with write cache and LUM prioritization)
2. the VM for the new SQL will have three volumes:
C for os and app RAID 10
E for DBs RAID 5 (with write cache)
F for logs RAID 10 (with write cache)
3. Two virtual CPUs of 2.4 ghz each (AMD Opteraon 885s) will be allocated to the server
4. Two or more GBs ram can be allocated to the server
I had hoped that becuase they have not stressed their older servers that this would okay with a fast disk subsystem and each of the two CPUs 4 time more powerful than one of their currently used ones....
How does it sound and what am I missing?
Again thanks for your review.....
September 12, 2006 4:42 PM
February 3, 2009 2:37 PM