Disk drive statistics collection provides the ability for SQL Diagnostic Manager to alert on disk drives and database space calculations. By default, SQL Diagnostic Manager attempts to auto-discover local disk drives on monitored instances. In some environments, the auto-discovered list may be incomplete or incorrect. The Customize disk drive statistics collection window allows you to turn off the auto-discover feature and manually add the drives for drive statistics collection.

SQL Diagnostic Manager populates the disk drive list using operating system metrics from a WMI call even if your collection is configured to use OLE automation. SQL Diagnostic Manager requires you to enter credentials to connect directly to WMI. This functionality lets SQL Diagnostic Manager quickly discover mount points while the OLE automation does not provide such information.

Access the Disk Drives tab

You can access the Disk Drives tab of the Monitor SQL Server Properties window by right-clicking the appropriate monitored SQL Server instance, and then selecting Properties. Click Disk Drives when SQL Diagnostic Manager displays the Monitored SQL Server Properties window.

Incomplete disk drive list

SQL Diagnostic Manager automatically discovers local disk drives on your monitored instances. Sometimes this list is incomplete or contains drives that are not related to SQL Server. If you need to modify this list, clear the Discover disk drives check box, and then type the drive information including mount points, if necessary, into the Available disk drives field. Select the appropriate drive or drives and then click Add to move the drive information to the Selected disk drives box. Click OK.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >