SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Using and Creating Mount Points in SQL Server


Using and Creating Mount Points in SQL Server

Author
Message
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)

Group: General Forum Members
Points: 71646 Visits: 17847
Comments posted to this topic are about the item Using and Creating Mount Points in SQL Server

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
M&M
M&M
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7487 Visits: 3913
Hi Perry,

Very nice to see your article. I will definetly try this out. Thank you for sharing your knowledge on these topics.

M&M
Rich Mechaber
Rich Mechaber
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3315 Visits: 3673
Thanks for an informative article Perry, but I'm left wondering what the benefit is to creating/using mount points is. For containing SQL system files, they seem like just another way to create a virtual disk/shortcut to space on an NTFS volume. Or am I missing something?

Rich
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)

Group: General Forum Members
Points: 71646 Visits: 17847
rmechaber (11/10/2011)
For containing SQL system files, they seem like just another way to create a virtual disk/shortcut to space on an NTFS volume.

They may be used for system files, database files, log files, tempdb files and backup files. As the article explains, you only have 26 drive letters total available to the operating system. Mounts points allow you to have multiple instances with multiple disk resources without the drive letter constraints.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
CDA
CDA
Old Hand
Old Hand (370 reputation)Old Hand (370 reputation)Old Hand (370 reputation)Old Hand (370 reputation)Old Hand (370 reputation)Old Hand (370 reputation)Old Hand (370 reputation)Old Hand (370 reputation)

Group: General Forum Members
Points: 370 Visits: 543
So, the one limitation, that I still see with mount points, is still doing any kind of logical detection of free-space.
Say I have a stub drive (drive letter) that's 500mb

xp_fixeddrives will ONLY see the stub drive freespace; it doesn't matter if I have mount points of 2 TB of space underneath it.
some vendor apps fail to install, saying there's not enough free space to complete installation based on this.

the only way I've figured out around this is to drop down into powershell and
gwmi win32_volume|where-object {$_.filesystem -match "ntfs"}|ft name,capacity,freespace



Anyone know of a way (or i'd like sql to have something built-in) to figure this out within TSQL?



L-P Larsson
L-P Larsson
Valued Member
Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)Valued Member (62 reputation)

Group: General Forum Members
Points: 62 Visits: 90
I have setup both our SQL test-environment and production environment, both are two node clusters.
I installed SQL Server first, and then mereley replaced the default installations folders with mount-point-folders via rename, xcopy /o <renamed-folder> <new-folder-with-default-name>

OS: WS 2008 R2 Enterprise
SQL 2008 R2 Standard

Some things I learned doing this are:

-there is a bug in Windows when setting permissions on the mounted folder - one has to do that first from disk management (right-click partition and set permissions). I had quite a lot of error messages doing that and it was impossible to just close the properties dialog by clicking Ok, I had to use Cancel. But afterwards the permissions are right if one checks.

-The amount of free space has to be checked for each "mount-point-folder" since the amount of free space in the root folder only show how much it is free of the root disk.

-When done and documented: Very nice to have one folder structure per sql instance and still have different write cache policies for data-folder, log-folder and temp-db-folder on each LUN that is used for mount point folder in the underlying storage system! Smile
k-335975
k-335975
Valued Member
Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)Valued Member (52 reputation)

Group: General Forum Members
Points: 52 Visits: 353
Perry,

I usually monitor Avg. Disk sec/Read and Avg. Disk sec/Write to check disk activity, without mount points adding this counters in perfmon is not an issue. But with mount points, I just see the letter of mount point and not underlying disks in the instance list of above counters. I tried to find the id's of the disks under mount points, but not able to relate those id's with actual disks.

Any ideas?

Thanks!
SAinCA
SAinCA
Mr or Mrs. 500
Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)Mr or Mrs. 500 (544 reputation)

Group: General Forum Members
Points: 544 Visits: 703
This may be a dumb question from a total mount-point novice...

The dialog boxes showed a max disk size of a smidge over 7GB. Where does that come from? Is it a limitation? What...? (As in, please elucidate 'cos I don't know enough to ask the "right" question...:-))

Thanks! Helpful article indeed on a topic I'd never heard of but had wondered for years how to get around the 23-user disk limitation.
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)

Group: General Forum Members
Points: 71646 Visits: 17847
SAinCA (11/10/2011)
The dialog boxes showed a max disk size of a smidge over 7GB. Where does that come from? Is it a limitation? What...? (As in, please elucidate 'cos I don't know enough to ask the "right" question...:-))

Are you referring to the volume size of 7165MB shown in the wizard images? That is slightly under 7GB. The LUN sizes I used can be seen in the first image showing the Windows disk management console, there were a combination of 6GB and 7GB LUNs.

Remember the formatted size will always be less than the initial disk size presented!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)SSC Guru (71K reputation)

Group: General Forum Members
Points: 71646 Visits: 17847
k-335975 (11/10/2011)
Perry,

I usually monitor Avg. Disk sec/Read and Avg. Disk sec/Write to check disk activity, without mount points adding this counters in perfmon is not an issue. But with mount points, I just see the letter of mount point and not underlying disks in the instance list of above counters. I tried to find the id's of the disks under mount points, but not able to relate those id's with actual disks.

Any ideas?

Thanks!

I do not have this information to hand at present. I will endeavour to provide this when I am back in blighty ;-)

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search