2008 R2 cluster install storage

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

High Availability (2008)

2008 R2 cluster install storage

Author

Topic

Charoniv
Starting Member

21 Posts

Posted - 2012-07-10 : 05:26:03

Hello
We are installing an active-active cluster with 2 instances, 2 machines.

The storage is mostly SAN
We have presented as cluster resources for each instance
1 disk for data
1 disk for log

And another quorum disk.

Would like another each for tempdb - would that be a good idea?
Any other suggestions?

Also what do I need to install sql server - would that be local resources, a clustered disk each, a single clustered disk?

Charoniv
Starting Member

21 Posts

Posted - 2012-07-10 : 05:32:55

It looks like the binaries go on local disks.
We have a c drive which has 34 GB free which should be OK.

Please feel free to agree or disagree :).

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-07-10 : 12:55:41

Yes you should have separate disks for tempdb. We put the tempdb data files on either one mount point or several, depending on the load. We then have a separate mount point for tempdb's transaction log file.

The installation bits go on local disks as you mentioned.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Charoniv
Starting Member

21 Posts

Posted - 2012-07-10 : 13:19:39

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources