Home Dashboard Directory Help

Listing mount point information from within SQL Server by Troels S Eriksen


Status: 

Closed
 as Won't Fix Help for as Won't Fix


13
0
Sign in
to vote
Type: Suggestion
ID: 301832
Opened: 10/1/2007 5:23:50 AM
Access Restriction: Public
2
Workaround(s)
view

Description


Neither SQL Server 2000, SQL Server 2005 or SQL Server 2008 is able to list existing mount points or mount point info (like total disk space and free space) through xp_fixeddrives or xp_available media or other extended stored procedures.

Neither does the Management Studio mark mount points as such, f.x. during the "New Database" dialog when you want to control where database files are stored this information would be nice - plus of course, a way to easily check that the wanted / needed space actually are available...

Currently the only way of identiftying that a given folder is a mount point through Management Studio is when the "System Volume Information" folder is shown in a subfolder.

Double mounting a drive through both a drive letter and a mount point is not an option on a cluster with many instances or luns attached + plus it may confuse backup systems, antivira software etc when the same drive is accessible through different paths.

Further there is a small problem with xp_fixeddrives and xp_availablemedia since they list cluster disk resources outside the scope of the current sql server instance.
Details
Sign in to post a comment.
Posted by Joie Andrew on 10/4/2012 at 8:03 AM
On servers that are Windows Server 2008+ what about making an extended stored procedure that queries the Win32_Volume WMI class? Our team now is trying to see if we can do that via a PowerShel query that outputs the resultset into variables that then get input into a table in SQL.

It would be nice if this could be done natively though. Extremely useful information considering how Enterprise systems are engineered nowadays.
Posted by Microsoft on 4/1/2011 at 1:19 AM
Hello:

Greetings from the SQL Server Manageability Team.

We triaged this enhancement along with several others. Unfortunately, considering the work involved in implementing this, and our current deliverables/committments, we regret to let you know that, we will not be able to implement this in the near future. We will keep track of this internally, and will get to it, when the opportunity arises.

Thanks for writing into Microsoft.

Cheers,

Chandramouli
SQL Server Manageability
Posted by Nilton Pinheiro - MVP on 10/29/2010 at 4:53 AM
Hi Guys...any workaround for this? So that more and more people are using mount point on SQL Server, sounds good if MS pay attention to this and at least provide a workaround.

thanks
Nilton Pinheiro
Posted by Microsoft on 11/20/2007 at 10:53 AM
Having the ability to manage the storage that the databases are configured on would be a valuable enhancement to the SQL product. Unfortunately, it won't fit in the current release. We are keeping your suggestion active for consideration in future releases.
Sign in to post a workaround.
Posted by Matt Man on 9/2/2014 at 11:52 AM
This community created SPROC, sp_FixedDrives will list detail for drives as well as mount points: http://www.mssqltips.com/sqlservertip/3037/getting-more-details-with-an-enhanced-xpfixeddrives-for-sql-server/
Posted by AussieJohn on 3/12/2012 at 8:19 PM
A workaround is to call a Powershell script from SQL Server using xp_cmdshell.