disk layout of sql server 2005 in cluster enviornm

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 2005 Forums

SQL Server Administration (2005)

disk layout of sql server 2005 in cluster enviornm

Author

Topic

sqlserverdbam
Yak Posting Veteran

54 Posts

Posted - 2009-03-10 : 15:35:49

Hi,

I want to architect disk layout of sql server 2005.
What is the best practice for MS SQLSERVER 2005 clustering disk layout?

Please let know if have any document etc.
thx

heavymind
Posting Yak Master

115 Posts

Posted - 2009-03-10 : 16:20:20

what do you mean "disk layout"? clustred groups? raid arrays for log/data/etc ?

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com

sqlserverdbam
Yak Posting Veteran

54 Posts

Posted - 2009-03-13 : 10:14:39

For cluster enviornment and non-cluster enviornment.like

raid arrays for log m: (Which RAID type)
raid arrays for data n: (Which RAID type)
raid arrays for temp o: (Which RAID type)
MS SQL SERVER binary c: (which raid type)

How many disk drives are suggested?

Thanks

trbryant
Starting Member

1 Post

Posted - 2009-03-19 : 15:03:19

This is a matter of preferrence and it seems as if everyone has their own "formula", however at this point we use:

log = RAID 10
data = RAID 5
tempdb = RAID 1

I also prefer bigger servers (memory, cpu, cores) with bigger I/O capacity and connect different HBA's to the SAN for each group. I hope this works.

quote:
Originally posted by sqlserverdbam

For cluster enviornment and non-cluster enviornment.like

raid arrays for log m: (Which RAID type)
raid arrays for data n: (Which RAID type)
raid arrays for temp o: (Which RAID type)
MS SQL SERVER binary c: (which raid type)

How many disk drives are suggested?

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources