May 17, 2012 at 4:21 pm
Hi,
We are having a debate with our SAN admins in configuring mount points on SAN.
DBAs: We are asking to configure each mount point to point a separate LUN on SAN
SAN Admin: SAN admin wants to create all mount points to point to a single LUN on SAN. Their argument is
1.It does not matter having each mount point to point a separate LUN on SAN or all mount points to point to a single LUN on SAN
2. SAN drives are striped across all drives and creating each mount point to point a separate LUN on SAN will cause SAN administration overhead
3.They are asking us provide a documentations from Microsoft where it says we need to configure each mount point to point a separate LUN on SAN.
Is there any Microsoft document on how to configure mount points on SAN for SQL Server 2008 R2?
Thanks
May 17, 2012 at 11:40 pm
Well, it depends.
If you have a standard 18-drive SAN, it doesn't matter whether you have one large LUN or several smaller LUNs all using the same spindles.
You really only have a performance advantage if you make sure that all the LUNs provided to you run on different spindles. As soon as the LUNs provided to you overlap on spindles, you might as well get one large one and then partition that to your needs.
Of course in the Server Manager GUI it looks better if all the Partitions are below each other (several small LUNs), as opposed to all partitions next to each other (one large LUN).
MS-White Paper:
Analyzing I/O Characteristics and Sizing Storage Systems for SQL Server Database Applications
http://technet.microsoft.com/en-us/library/ee410782(v=sql.100)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply