Space Analyst for Microsoft - Objects Tab

From DBArtisan
Jump to: navigation, search

Go Up to Using Space Analyst

The Objects tab displays database objects, including tables and indexes.

You can choose whether to view table or index information by clicking either the Tables or Indexes ratio buttons. You can also choose whether to view general space information for tables and indexes or reorganization metrics by selecting the General Space or Space Diagnostics radio buttons.

Note: To obtain space diagnostic information for each object, Space Analyst uses the SQL Server DBCC SHOWCONTIG command. This command may take a while to run on large databases.

The Object summary presents one of two views:

  • When the General Space radio button is pressed, a graph is presented that visually displays that amount of allocated space (in KB) for tables, indexes, and free space. For large servers, not all objects for a database will initially be visible on the chart, but the graph is scrollable so you can click the graph and scroll to see all database objects on the chart.
  • When the Space Diagnostics radio button is pressed, Space Analyst presents a count of all objects (tables or indexes) that exceed your customizable thresholds for various forms of fragmentation of other space-related inefficiency. See below for a thorough discussion of these types of space problems.

The Object Details grid presents one of two views:

  • When the General Space radio button is pressed, general space usage for tables or indexes is shown. Base object metadata (object name, type, partitions, etc.) is shown along with the amounts of total, used, and free space (in KB) for the object. The percent of space used for the object is also shown along with the percent of space in the database that the object consumes.
  • When the Space Diagnostics radio button is pressed, Space Analyst present fragmentation and other space-related inefficiency information for all objects in the selected database. Note that definitions for all the various forms of object fragmentation and space inefficiencies follow later in the help.

The table below describes the options and functionality on the Objects tab of Space Analyst:

View Description

Database

Lets you switch between databases.

Tables

Lets you switch between viewing space for tables and indexes. Displays object details when you select.

Indexes

Lets you switch between viewing space for tables and indexes. Displays object details when you select.

General Space View

Displays general space information for tables and indexes in the selected database. Displays object details when you select.

Space Diagnostic View

Displays fragmentation and space information to help the DBA decide if a reorg is necessary. Displays object details when you select.

File Group

Lets you view object data for all filegroups for the database or only a selected filegroup.

Owner

Lets you view object data for all table owners or only a selected owner.

Display

Lets you view space diagnostic information for tables or indexes.

Available Functionality

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

Topics