August 31, 2012 at 7:55 am
We have several Standalone SQL Server 2005 Servers in Production each with Multiple Instances.
We will be building out a new SQL Server 2008R2 HA Active\Passive Cluster and I had a couple of Questions.
On our Standalone Servers, I have the Database Data and Log files and TempDB files on seperate drives for performance reasons. On the cluster, our shared storage for the cluster will be on a SAN. Is it necessary to split out the data and log file and Tempdb on different volumes in this scenerio? In other words, how does everyone else do it?
Also, any good tutorials on installing SQL Server 2008 R2 Standard in a Cluster???
any help would be greatly appreciated.
August 31, 2012 at 8:05 am
Jpotucek (8/31/2012)
We have several Standalone SQL Server 2005 Servers in Production each with Multiple Instances.We will be building out a new SQL Server 2008R2 HA Active\Passive Cluster and I had a couple of Questions.
On our Standalone Servers, I have the Database Data and Log files and TempDB files on seperate drives for performance reasons. On the cluster, our shared storage for the cluster will be on a SAN. Is it necessary to split out the data and log file and Tempdb on different volumes in this scenerio? In other words, how does everyone else do it?
Also, any good tutorials on installing SQL Server 2008 R2 Standard in a Cluster???
any help would be greatly appreciated.
Yes, data files & log files should be on separate drives. Data file is accessed randomly whereas log file is accessed sequentially. That is why you might want to put the data file on a drive with RAID 5 (as number of reads is high than number of writes for a data file) & log file to RAID 10.
In the end you need to evaluate what kind of disk configuration you have got & then decide accordingly.
August 31, 2012 at 8:22 am
Jpotucek (8/31/2012)
We have several Standalone SQL Server 2005 Servers in Production each with Multiple Instances.We will be building out a new SQL Server 2008R2 HA Active\Passive Cluster and I had a couple of Questions.
On our Standalone Servers, I have the Database Data and Log files and TempDB files on seperate drives for performance reasons. On the cluster, our shared storage for the cluster will be on a SAN. Is it necessary to split out the data and log file and Tempdb on different volumes in this scenerio? In other words, how does everyone else do it?
Also, any good tutorials on installing SQL Server 2008 R2 Standard in a Cluster???
any help would be greatly appreciated.
Note: that if these logical Windows disks are LUNs carved out of the same physical SAN array you're going to realise performance, especially if there are LUNs servicing other applications on the same SAN array.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 31, 2012 at 8:46 am
The logical Windows disks are LUNs carved out of the same physical SAN array so it sounds like it doesn't matter if the data and log files and tempd are split up.
I was wondering how other people do it and whether there is any good documentation for best practices installing multiple Instances in a 2008 R2 Cluster??
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply