CPU consumption related to Indexes in Timextender Classic Repository Database¶

Symptoms¶

High CPU consumption by the Timextender repository database. Error Message received:

Cause¶

High CPU consumption is can be caused by indexing on the repository tables.

Resolution¶

To address the high CPU consumption, you can add or modify indexes in the repository tables. However, there are a few considerations to keep in mind:

1. Adding or modifying indexes may improve execution and reduce CPU consumption.
2. The changes might be overwritten every time the table is deployed.
3. There is a risk that the changes could cause errors when using or running the table or project.

Steps to add a non-clustered index:

1. Backup your databases before making any changes to avoid issues if the changes do not work as expected.
2. Execute the following SQL script to create a non-clustered index:

USE [timextender_repository]
GO
CREATE NONCLUSTERED INDEX IX_ExecutionPagageLogDetails_Idx
ON [dbo].[ExecutionPackageLogDetails] ([ObjectId],[Start],[End])
INCLUDE ([StepId])
GO

Reference Ticket¶

32241

Reference Links¶

Health-chek for TX