Listing mount point information from within SQL Server

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

Closed

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

Type:	Suggestion
ID:	301832
Opened:	10/1/2007 5:23:50 AM
Access Restriction:	Public

Workaround(s)

view

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 (expand)

English

SQL Engine

Make SQL Server fully mount point aware by adding the ability to list mount points and mount point info (space used, total space etc etc) to both Management Studio and SQL Servers internal "extended" stored procedures like xp_fixeddrives.

Faster Development

Improved Reliability

Improved User Interface

Improved Administration

0 attachments

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.

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.