Show TOC

Space: OverviewLocate this document in the navigation structure

Use

You find this function in the DBA Cockpit when navigating to Start of the navigation path Space Next navigation step Overview End of the navigation path.

The Space Overview monitor gives you information about the allocation of space in the database. The initial screen presents the most important information for:

  • The entire database
  • Individual database files
  • Database objects: Tables, indexes, stored procedures, etc.

In addition to the information presented, the monitor offers a set of functions that help you to analyze and check various properties of the database, tables or indexes in greater detail.

Features

The information overview entrance screen is divided in the sub screens Overview, Files and Objects. You can switch between sub screens with the corresponding tab-riders. The initial screen of the monitor is grouped into three different categories: Data, Log, and Oldest open transaction. In addition, the last known good dbcc checkdb date and time is shown, and an indicator for errors flagged in the Files screen.

With the Refresh button you can update the information.

Overview

Screen Area Information

Database

The name of the database is displayed in a dropdown box. You can choose a different database.

Data
  • The total number and size of all database files
  • The allocated and free areas within the files in size and percentages

Log
  • The number and size of transaction log files.
  • Space allocated, free space and used space
  • Recovery model
  • Reuse wait reason

    If there is a problem writing the log, the reason is shown here.

Oldest open transaction

Shows when the oldest open transaction on the server started, and the session ID of that transaction.

Files

This subscreen shows a detailed list of the database files and their attributes.

Objects

This sub screen shows a list of the database schemas and the number and size of tables and stored procedures. Below the schema list is a selection listbox, which allows a closer examination of individual schemas. The details of the currently chosen schema are shown in a list, which lists various types of objects contained within the schema. The retrieval and classification of all objects in all schemas can be an expensive operation. In the latest versions of this screen, a button labelled Get Schema Information appears. This lets the user retrieve the object information only when needed.