Skip to main content

SQL_DatabaseSizing Job

The SQL_DatabaseSizing Job provides details on database file sizes and overall database sizes.

Analysis Tasks for the SQL_DatabaseSizing Job​

Navigate to the Databases > Jobs > SQL > 4.Configuration > SQL_DatabaseSizing Job >Configure node and select Analysis to view the analysis tasks.

warning

Do not modify or deselect the selected analysis tasks. The analysis tasks are preconfigured for this job.

Analysis Selection

The default analysis tasks are:

  • Database Size Details – Provides details on database files and sizes
  • Database Size Summary – Summarizes database file sizes by database

In addition to the tables created by the analysis tasks, the SQL_DatabaseSizing Job produces the following preconfigured report:

ReportDescriptionDefault TagsReport Elements
Database SizingThis report provides details on database files and sizing.NoneThis report is comprised of three elements:
  • Bar Chart – Provides information on the top five databases by size (MB)
  • Bar Chart – Provides information on database sizes by host (GB)
  • Table – Provides details on database sizing