DBA xPress Data Space Analyzer

Overview

IconDescription
DBA xPress Data Space Analyzer IconData Space Analyzer assists DBAs with managing their SQL Server instances by displaying graphs that provide information about their disk space usage.

Feature Highlights
  • Displays your database disk usage data

Using Data Space Analyzer

Use Data Space Analyzer for your selected instance by completing the following steps:

1. Select Data Space Analyzer on the SentryOne Workbench to open the Choose Server or Database window.

DBA xPress select Data Space Analyzer

2. Enter a SQL Server connection or select a previous connection from the drop down list. Enter your connection credentials, then select a database for the analysis. Select OK to display a graph of your database.

DBA xPress Data Space Analyzer Connect to Database
DBA xPress Data Space Analyzer Connect to Database Credentials
DBA xPress Data Space Analyzer Connect to Database select Ok

Note:  Data Space Analyzer automatically starts a search for local servers when it starts. Select Find Local Servers if you know a new server has appeared since the application started, or the dialog opens before the initial search completes.

Note:  Selecting SQL Server Security gives you the option to enter a username and password. Select a server and select OK to profile space usage on the server as a whole, select a database to profile space usage on that single database.

3. Select the graph to display more details about the file, and display a break down of the project.

DBA xPress Data Space Analyzer Database Graph
DBA xPress Data Space Analyzer Primary Graph
DBA xPress Data Space Analyzer Table Graph

Note:  Return to a previous graph by selecting the graph name on the top left of the display. DBA xPress Data Space Analyzer return to previous view

Data Space Analyzer Data

DBA xPress Data Space Analyzer Data Statistics

Table of Characteristics

The Data Space Analyzer reports display a number of characteristics in the list of objects at the bottom of the page. You can also hover over an item in the chart. The following is a list of displayed Data Space Analyzer characteristics:

CharacteristicDescription
File SizeThe total size of files that make up a file group in a database.
Allocated SpaceThe space within a database that is reserved for usage by a table or an index.
Unallocated SpaceThe space within a database file that has not been reserved.
ReservedThe total amount of space that has been reserved for a table or an index.
UsedThe total amount of space which is being actively used by a table or an index.
In-Row DataThe space which is being used for the main data storage of table rows.
Overflow/LOB DataThe space which is used for LOB types (text, ntext & image) or for overflow data associated with overflow types (varchar(MAX), nvarchar(MAX), varbinary(MAX) & xml).
Index DataThe space which is used for storing indexes on a table or view.
FreeThe space that has been reserved for table usage but is not currently in use.
RowsThe total row count associated with an entity. Note that the total row count for SQL Server 2000 servers is estimated.
Average Page FragmentationThe amount of fragmentation that an index or a table has. Note that This information is not available on SQL Server 2000 servers, or when using the faster data loading mode on SQL Server 2005+ servers.

Tables of Charts

The following is a list of the charts that are available in Data Space Analyzer:

Chart NameChart DestinationList Destination

Databases by total allocated space

Data spaces by total allocated space

Data spaces by total allocated space

Databases by total file group size

Data spaces by total file size

Data spaces by total file size

Databases by total page type size

Data spaces by selected page type total size

Data spaces by total page type size

Databases by row count

Data spaces by row count

Data spaces by row count

Databases by total unallocated space

Data spaces by total unallocated space

Data spaces by total unallocated space

Page type summary

Data spaces by selected page type total size

Data spaces by selected page type total size

Data spaces by selected page type total size

Storage objects by total allocated space

Storage objects by total allocated space

Data spaces by total allocated space

Storage objects by total allocated space

Storage objects by total allocated space

Data spaces by total file size

Storage objects by total allocated space

Storage objects by total allocated space

Data spaces by total page type size

Storage objects by selected page type total size

Storage objects by total allocated space

Data spaces by row count

Storage objects by row count

Storage objects by row count

Data spaces by total unallocated space

Storage objects by total allocated space

Storage objects by total allocated space

Partitions for index by row count

N/A

N/A

Partitions for index

N/A

N/A

Indexes on storage object by row count

Partitions for index by row count

Partitions for index by row count

Indexes on storage object

Partitions for index

Partitions for index

Page type summary for storage object

Indexes on storage object

Indexes on storage object

Storage objects by selected page type total size

Page type summary for storage object

Page type summary for storage object

Storage objects by total allocated space

Indexes on storage object

Indexes on storage object

Storage objects by row count

Indexes on storage object by row count

Indexes on storage object by row count

Toolbar Options

DBA xPress Data Space Analyzer Toolbar

View Options

OptionDescriptionImage
PieDisplays the selected database graph as a pie chart.DBA xPress Data Space Analyzer Pie Chart Graph
TorusDisplays the selected database graph as a torus chart.DBA xPress Data Space Analyzer Torus Chart Graph
BarDisplays the selected database graph as a bar chart.DBA xPress Data Space Analyzer Bar Chart Graph
ManhattanDisplays the selected database graph as a Manhattan chart.DBA xPress Data Space Analyzer Manhattan chart Graph
New tab from hereOpens a new duplicate tab of the currently selected graph.DBA xPress Data Space Analyzer New tab from here

Data Options

OptionDescriptionImage
RefreshReloads the data for the selected graph.DBA xPress Data Space Analyzer Refresh
Export Image

Save the selected graph as one of the following image files:

  • .png 
  • .jpg 
  • .bmp
DBA xPress Data Space Analyzer Export Image
Export dataSave the selected graph as a .csv file.DBA xPress Data Space Analyzer Export data
Jump toReorganizes the data to focus on one of the following selections:
  • Data Spaces by Total File Size
  • Data Space by Total Allocated Space
  • Data Spaces by Total Unallocated Space
  • Data Spaces by Total Page Type Size
  • Data Spaces by Total Row Count
  • Page Type Summary
DBA xPress Data Space Analyzer Jump to