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.

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 OLTP SQL cluster on VMware

Author  Topic 

rdecker
Starting Member

1 Post

Posted - 2010-08-18 : 04:15:46
We're planning to use VMWare to host an OLTP SQL database cluster. Here's our plan [url=http://xenmaster.com/VMWareEMCDatacenter.aspx][/url].
OS's, SQL logs and SQL data will have their own LUNs.

We have a few questions for SQL experts:
Do you see any problems with this design or even putting SQL on a VMware environment? We're looking at 10K concurrent users with short, bursty queries.
Anyone running OLTP SQL on VMWare? Please share any pointers on what to look for and what to expect in a VM environment.

Thanks in advance

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2010-08-18 : 04:57:10
vmwares have gone a long way...if asked 3 years ago, i would have advised a don't do it

in addition to what you are planning, make sure you have a separate LUN for tempdb so you can manage this separately, create more tempdb data files in accordance to the number of cpu's you intend to have

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -