Session 2: Obtaining a Global View of Storage Using Space Analyst for Microsoft
When first invoked, Space Analyst displays a complete overview of the storage situation of a particular SQL Server. The first tab of Space Analyst can be used to see all pertinent global statistics regarding storage structure usage throughout a server.
There are four distinct sections displayed on the first tab (labeled Storage Overview) of Space Analyst:
Space Analyst for Microsoft - Server Overview
The total count of all databases, file groups, and files are shown in this section. You can also see the percentage breakdown of the database vs. log space on the server. Positioning the mouse pointer over the graph causes it to display the actual percentage amounts for storage type.
- Tip: If you want to see a grid-style display of the information shown in most graphs, position your mouse over the graph, click the right mouse button and select the 'toggle display' option.
Space Analyst for Microsoft - Database Overview
Summary information regarding every database on the server is present in the database overview section. When invoked in graph form, this section shows how much total space is used by each database. When shown in grid form, this section shows not only the total space used for each database, but also includes the total allocated, free, and percent free amounts, along with an indicator that shows whether any of the database's underlying datafiles can automatically grow if necessary.
- Tip: To see a grid-style display of the information shown in the graph, position your mouse over the graph, click the right mouse button and select the ‘toggle display’ option. To return to the graph, just perform the same actions over the grid.
When this section is in grid form, you can also perform a number of actions on a database like open it in a DBArtisan editor, extract its DDL, shrink it, and more. For example, if you want to open a database in DBArtisan's database manager, do the following:
- In the grid, select a database.
- Right-click and select Open.
- Select a database and click the Open toolbar button.
- DBArtisan opens the Database Manager.
Space Analyst for Microsoft - Log Overview
The log overview provides a quick glance into database transaction log usage. When invoked in graph form, this section shows the percentage of used log space per database. When shown in grid form, this section shows not only the total percentage of transaction log space used for each database, but also includes the total allocated and free amounts (in MB), along with an indicator that shows whether any of the database's transaction logs underlying log files can automatically grow if necessary.
Space Analyst for Microsoft - Server Disk Overview
The server disk overview provides a window into how much free space exists on the actual server machine. In graph form, this section shows the amount of free space (in MB) across each of the server's drives. When in grid form, it shows free space per drive, but also includes the amount of allocated SQL Server data and log space per drive.