June 22, 2015 at 8:34 pm
Hi,
I have a 2 node Windows 2012 Cluster which runs a couple of SQL2012 FCIs. SAN backend for storage. I am using mount points for the Data/Log LUNs to avoid using a ton of drive letters.
What is a best practice for creating a volume to host the drive letter SQL points to? Right now I created a small (1GB) LUN and dedicate that LUN to the drive letter. As part of the WSFC Role for each SQL FCI, the "Drive Letter LUN", Data and Log LUNs all failover to the other node. The Data/Log LUNs have a dependency on the "Drive Letter LUN"
Example [SQL FCI 1]:
LUN_MP - 1GB for the H: drive
LUN_Data - 150GB (mount point)
LUN2_Logs - 50GB (mount point)
I mean this is working perfectly fine and I haven't had any issues with it, but just curious if there is a better way.
Thanks!
-Dan
June 23, 2015 at 12:14 am
That might be interesting... what other thinks.
We're doing it the same way... works perfect for us.
June 23, 2015 at 5:39 am
dan-404057 (6/22/2015)
I have a 2 node Windows 2012 Cluster which runs a couple of SQL2012 FCIs. SAN backend for storage. I am using mount points for the Data/Log LUNs to avoid using a ton of drive letters.
Perfectly acceptable and logical design
dan-404057 (6/22/2015)
What is a best practice for creating a volume to host the drive letter SQL points to? Right now I created a small (1GB) LUN and dedicate that LUN to the drive letter.
Yes, this is correct, ideally the LUN should be as small as possible. 100MB is usually sufficient, a small root drive stops people dumping rubbish onto it 😉
dan-404057 (6/22/2015)
As part of the WSFC Role for each SQL FCI, the "Drive Letter LUN", Data and Log LUNs all failover to the other node. The Data/Log LUNs have a dependency on the "Drive Letter LUN"Example [SQL FCI 1]:
LUN_MP - 1GB for the H: drive
LUN_Data - 150GB (mount point)
LUN2_Logs - 50GB (mount point)
I mean this is working perfectly fine and I haven't had any issues with it, but just curious if there is a better way.
Thanks!
-Dan
No, that is the correct way, the mounted volumes have a dependency on the root drive, this must be online first
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 23, 2015 at 10:54 am
Thanks for the input! Much appreciated.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply