Space Analyst - Storage Overview Tab
Go Up to Using Space Analyst
The Storage Overview tab displays an overview of the storage/space situation on the target server:
The table below describes the sections on the Storage Overview tab of Space Analyst for Microsoft:
Section | Description |
---|---|
Server Overview |
Overview of total database and log space allocated on the SQL Server, as well as a count of databases, files, and file groups. |
Log Overview |
Contains a graphical and grid control that works in the following way: - When the graph is displayed, a bar chart is shown that lists the total percent used of all logs on the server. - When the grid is displayed, detailed storage information for each database log is presented. |
Database Overview |
Contains a graphical and grid control that works in the following way: - When the graph is displayed, a bar chart is shown that lists the total space usage of all databases on the server. - When the grid is displayed, detailed storage information for each database is presented. |
Server Disk Overview |
Contains an overview of total free space, by physical server drive, of the server that houses SQL Server. |
The table below describes the sections on the Storage Overview tab of Space Analyst for Sybase ASE:
Section | Description |
---|---|
Server Overview |
Overview of total database and log space allocated on the Sybase ASE Server, as well as a count of databases and devices. |
Log Overview |
Contains a graphical and grid control that works in the following way: - When the graph is displayed, a bar chart is shown that lists the total percent used of all logs on the server. - When the grid is displayed, detailed storage information for each database log is presented. Database name Total log space Free log space Used log space Log percent free |
Database Overview |
Contains a graphical and grid control that works in the following way: - When the graph is displayed, a bar chart is shown that lists the total space usage of all databases on the server. - When the grid is displayed, detailed storage information for each database is presented: Database name Total database space Database free space Database used space Database percent free |
Device Overview |
Contains a graphical and grid control that works in the following way: - When the graph is displayed, a bar chart is shown that lists the total space used (in MB) of all devices defined to the server. - When the grid is displayed, detailed storage information for each database device is presented: Device name Physical name Total space Used space Free space Percent free Percent used |
Available Functionality
The following functionality is available in the Command menu, shortcut menu, and toolbar for Microsoft:
- Analysis Report
- Extract
- Map
- Databases Wizard (SQL Server)
- Object Details
- Open Editor
- Open Wizard
- DBCC
- Shrink
- Threshold Options
Available Functionality
The following functionality is available in the Command menu, shortcut menu, and toolbar for Sybase ASE:
- Analysis Report
- Extract
- ndex Details
- Open Editor
- Open Wizard
- Databases Wizard (Sybase ASE)
- Move Log
- DBCC
- Table Details
- Threshold Options