How to manage the size and growth of your SysKit database?

Have you ever wondered if there is a way to use SysKit to manage the size and growth of your SysKit database?

If your SysKit database is hosted on a local SQL Server Express instance, you are certainly aware of the limited space you have, and if you encounter a problem, you might wonder how to fix this inconvenience.

Of course, you need to consider a few things before you go on a deleting spree.

This blog post will guide you through using SQL Server Management Studio and SysKit to acquire certain information and reports to help you recalculate your database size.

Database size

To find out how big your database is, open SQL Server Management Studio:

  1. Connect to the SQL server that hosts your database.
  2. In the Object Explorer window, right-click on your database and choose Properties from the drop-down menu.
  3. Select General to view the size of your database.

    Image 1 – Database size

    Image 1 – Database size

Available space

In the Database Properties dialog box, select General to determine how much space is available for the selected database.

If your database has pregrown to a certain size and has a lot of free space, you can shrink it. To learn how to shrink a database, click here.

Determine Disk Usage

To display data and log space information for a certain database, follow these steps:

  1. Open SQL Server Management Studio and go to Object Explorer.
  2. Expand the Databases.
  3. Right-click the database, point to Reports, then point to Standard Reports and click Disk Usage.

    Image 2 – Disk Usage report

    Image 2 – Disk Usage report

If your log files are taking up a lot of space, you can reduce them by setting your database to the Simple recovery model and performing a backup.

  1. Connect to the SQL server that hosts your database.
  2. In the Object Explorer window, right-click the database and choose Properties from the drop-down menu.
  3. Select Options to view the size of your database.

    Image 3 – Recovery Model

    Image 3 – Recovery Model

To learn more about specific recovery models, click here.

Disk Usage by Table

To determine how much data SysKit is consuming based on different metrics it stores, you can use the Disk Usage by Table report.

  1. Open SQL Manager Studio and navigate to the database level.
  2. Right-click the database, point to Reports, then point to Standard Reports and click Disk Usage by Table.
  3. Set the sorting for the Data column to descending order.

The report will list the space used by each table. You can then analyze the data closely yourself or send the report to us for further inquiry.

Image 4 – Disk Usage by Table

Image 4 – Disk Usage by Table

Data retention

SysKit comes with a built-in data retention feature. You can configure SysKit to delete data you no longer need.

To configure the length period after which SysKit automatically deletes data from the database, follow these steps:

  1. Start SysKit.
  2. In the reports ribbon, click Options.
  3. Go to Data Retention, click the Enable data retention check box, and set the appropriate retention period. Click Save.

    Image 5 – Data Retention configuration

    Image 5 – Data Retention configuration

Please note that the default retention period for performance counters is 30 days, and the default period for other counters is 5 years. You can choose different retention periods that are better suited to your needs.