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 |
|
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 itin 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... |
 |
|
|
|
|
|
OLTP SQL cluster on VMware