Space Analyst Product Design

From DBArtisan
Jump to: navigation, search

Go Up to Space Analyst Application Basics

The Space Analyst product design includes tabs for Oracle, Microsoft SQL Server and IBM DB2.

Oracle Space Analyst Tabs

The Space Analyst includes the following tabs:

Microsoft SQL Server Space Analyst Tabs

The Space Analyst includes the following tabs:

IBM DB2 Space Analyst Tabs

The Space Analyst includes the following tabs:

Sybase ASE Space Analyst Tabs

The Space Analyst includes the following tabs:

Database Overview Tab

The Database Overview tab displays the storage overview for the DB2 datasource.

There are four distinct sections displayed on the first Database Overview tab of Space Analyst:

  • Database Overview
  • Log Overview (DB2 Only)
  • Tablespace Space Overview
  • Tablespace Fragmentation Overview
  • Tablespace Objects Overview

Data Files Tab

The Data Files tab displays datafile fragmentation information, and displays how much space in each datafile is assigned to tables, indexes, clusters, and rollback segments.

Tablespace Map Tab

The Tablespace Map tab allows for tablespace mapping.

Tables Tab

The Tables tab lets you identify tables with wasted space. The Space Analyst computes a block inefficiency ratio that quickly communicates the severity of the space problem. Space Analyst provides a summary count of all tables in a database that violate a customizable block inefficiency threshold, details on the tables, and the extent of wasted space.

Indexes Tab

The Indexes tab lets you select index reorganization candidates. The tab also offers the option to obtain deleted leaf row information for each index, although such data gathering can take some time, especially on large systems.

Space Analyst runs diagnostics against your database and graphically display a count of indexes that are found to contain various types of space problems.

Tablespaces Tab

The Tablespaces tab displays the Tablespace Container allocations and Database Partition Breakdown for each Tablespace.

There are three distinct sections displayed on the Tablespaces tab of Space Analyst:

  • Space Allocation by Container
  • Space Allocation by Node
  • Tablespaces