Space Analyst - Storage Overview Tab

From DBArtisan
Jump to: navigation, search

Go Up to Using Space Analyst

The Storage Overview tab displays an overview of the storage/space situation on the target server:

The following table 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 following table 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, and 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, and 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, and Percent used.

Functionality Available for Microsoft=

The following functionality is available in the Command menu, shortcut menu, and toolbar for Microsoft:

Functionality Available for Sybase ASE

The following functionality is available in the Command menu, shortcut menu, and toolbar for Sybase ASE:

Topics