Does MSSQL 2000 run in VMware ESX? We are planning on going into a virtualized environment and are wondering if main production database will run in VMware ESX. We cannot upgrade the SQL version.
Yes, it runs just fine in VMware - hopefully it's a lightly loaded database server rather than a multi-terabyte monster!
Ideally, you'd want a fresh install of Windows and SQL Server 2000, but failing that a P2V will work. Brent Ozar refers to it as taking care of dinosaurs:
The only time I got caught out with this approach was when a SQL2000/Windows2000 box was cloned (P2V), and then taken from its original domain to a new domain. SQL got a bit confused as the servername is embedded during install.
I've done this with dozens of legacy systems. Without fail, they run better in the virtualized environment (which is newer hardware). The flexibility to move between physical systems, free up (or preferably, retire) hardware, and consolidate is just great.
The dogma around SQL Server not playing well with virtualization amazingly still lingers, and is still misguided. Unless you're running on a type 2 hypervisor or have overcommitted resources, it's straightforward to make SQL Server play well with others.