Prem Mehra and Mike Ruthruff
In an earlier blog, Deploying SQL Server 2005 with SAN #1, we addressed three topics: 1) the core SQL Server requirements with respect to IO subsystem, 2) the complexity introduced by virtualization of the IO subsystem and 3) the type of RAID level to choose.In this one we want to focus on how best to assign SQL Server objects – logs, data and index objects for persistent and temporary data bases - to LUNs for achieving good performance while keeping design simple. We need to consider four types of objects – logs, persistent data / index objects, TempDB, and flat files for backups and incoming / outgoing files for interfacing with external systems. Recommendations are as follows:
In one of the future blogs, we will focus on establishing base line SAN performance prior to deploying SQL Server.
The search on this site doesn't work well, but try using the tags link on the side:
PingBack from http://greenteafatburner.info/story.php?id=3867