Cookie Consent by Free Privacy Policy Generator Update cookies preferences

Database Maintenance

You will need to perform occasional maintenance on the Tascus database to ensure optimal performance, use SQL Server Management Studio to do this, and complete these checks and tasks.

Check the overall database size

Use the following query to get the overall size of the database:

sp_spaceused

You can also use Reports > Standard Reports > Disk Usage

image.png

As a guide, a Tascus database in high-volume production use has an overall size of 11GB after 4 years.

image.png

Check the size of all tables

Use the following report to get the size of each table, to understand how the space is being used, and if that use is appropriate.

image.png

The same example database has the following table usage:


image.png

In this database, the largest amount of space is taken up by the StepList_Draft (95,575 rows) and StepList_Released (12,675 rows) tables - these are the tables where the steps for each sequence are saved (1 row = 1 step in a production sequence).

Both of those tables also have large indexes - which are designed to improve query speed when loading steps in a sequence.

Indexes

Create the following indexes on the database to improve query performance.


Screenshot-2023-10-06-134343.png

Was this article helpful?

Thanks for your feedback!