Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Storage in a Virtual Machine (2008 SQL on Windows 2012 on Hyper-V 2012 host) Expand / Collapse
Author
Message
Posted Saturday, June 29, 2013 9:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 12, 2014 7:36 AM
Points: 3, Visits: 613
For a small business where SQL instance is running 8 Databases supporting only 20 users and low number of transactions per second.

In a virtual environment do the traditional recommendations for SQL, i.e. separating log files from data files from Temp db on their own spindles still apply? If not and all can reside on the same OBR10 are there pros/cons performance wise for using separate VHDs for each?

We are new to RAID and Virtual environments and have read more documentation/articles than I can count. Some advise from those who "Do" will be greatly appreciated.


StillCrazy
Post #1468803
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse