The Space Analyzer tool helps you identify the disk space usage for SQL Server instances across your enterprise. With this tool, you can easily and proactively anticipate when you need to being new instances online, plan for new databases, and authorize hardware upgrades.
The Space Analyzer tool does not support mirrored databases. You can view disk space usage for your principal database, but not for any mirrored database.
How the Space Analyzer tool works
Space Analyzer allows you to view SQL Server user database storage statistics or view disk space usage statistics, such as the amount of available space on hard drives across computers that are hosting SQL Server instances. You can also discover which computers or SQL Server instances need immediate attention by quickly viewing the summary status.
The Space Analyzer tool displays the following percentages:
- % Used shows how much of a file is being used
% Disk Used shows how much of the whole drive is being used
% Used by Database Files shows how much of that drive is being used by that file
By default, Space Analyzer connects to the specified SQL Server instances using the credentials of your currently logged on Windows account, and then collects size and usage information about each database.
Use the Space Analyzer tool
To use Space Analyzer:
- Open the IDERA SQL Admin Toolset Launchpad, and then click Space Analyzer.
Specify the SQL Server instance or server group whose disk space usage you want to view. To specify multiple SQL Servers, separate each instance name with a semicolon.
Click Load Space Statistics.
View the results for each disk drive and SQL Server instance hosted by the corresponding computer. For more details, select the disk drive, instance, or user database in the tree, and view the statistics grid in the right pane.
If you want to save the results, click Copy Results To Clipboard, or save the results as an XML or CSV file.