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

Virtual Server Disk Configuration Expand / Collapse
Author
Message
Posted Monday, March 14, 2011 10:52 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 3:41 AM
Points: 453, Visits: 568
I have been tasked with moving our SQL server estate onto new 64bit SQL 2008 Virtual servers on a VM base. Each Virtual server will be attached to our SAN that i will have no control over. Do i ask for multiple LUNs pretending that there is a COS), Etemp), FData) and Glog) disk structure or do I just present a very big space as a single C: drive and let it go. We are consolidating lots of old physical servers onto fewer (more powerful) virtual servers (according to the VM and SAN administrators)
I have been searching the internet for comment / advice and at the moment I can boil most of what I have read down to
1. Configure your SAN properly
2. Don't overallocate shared resource

all advice, experience and opinion gratefully received and read
Post #1077849
Posted Monday, March 14, 2011 1:20 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:02 PM
Points: 7,081, Visits: 12,574
Martin Stephenson (3/14/2011)
Do i ask for multiple LUNs pretending that there is a C:\ (OS), E:\ (temp), F:\ (Data) and G:\ (log) disk structure or do I just present a very big space as a single C:\ drive and let it go.
Its depends on a lot of factors...

What type of SAN is it? If your SAN does virtualized peer storage (Bing EqualLogic) then a single C:\ will be fine and will save you a ton of research and decisioning. If you are using a SAN where you're managing physical spindles (i.e. spindles are not virtualized in the SAN) and you are forced to worry about spindle-isolation then you should seriously consider having separate volumes with dedicated spindles behind them for OS, tempdb, data and logs with appropriate RAID levels for each.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1077965
Posted Tuesday, March 15, 2011 9:26 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 3:41 AM
Points: 453, Visits: 568
HP EVA 4400, which gives us virtualised storage, my take on this is that it makes my life easier.
I am tempted to create an OS drive and a Data drive to help me manage things and protect the OS because developers and application administrators have been known to fill every available byte given to them with very important data that stops the databases from working due to having no space.
Post #1078430
Posted Tuesday, March 15, 2011 9:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:02 PM
Points: 7,081, Visits: 12,574
Martin Stephenson (3/15/2011)
HP EVA 4400, which gives us virtualised storage, my take on this is that it makes my life easier.
I am tempted to create an OS drive and a Data drive to help me manage things and protect the OS because developers and application administrators have been known to fill every available byte given to them with very important data that stops the databases from working due to having no space.

I am big fan of virtualized storage when the system does not require the granularity of control isolated spindles offers. Having an OS volume separate from a Data volume to protect against drive fill-ups is definitely a good call.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1078445
Posted Tuesday, March 15, 2011 2:38 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:40 AM
Points: 7,001, Visits: 8,439
have a look at http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/11/22/virtualizing-sql-on-vmware-reference-list.aspx

Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1078666
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse