Errors in Spotlight: "Collection 'IndexLatchWaits' failed : Lock request time out period exceeded" (4224386)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Errors in Spotlight: "Collection 'IndexLatchWaits' failed : Lock request time out period exceeded"
Description

The following collection failures appear in Spotlight:
"Collection 'IndexLatchWaits' failed : Lock request time out period exceeded. The statement has been terminated. [1222]"
Resolution

WORKAROUND:
1. Login to Diagnostic Server machine and backup following files to a different folder:
{Diagnostic Server installation folder}\Agent\conf\Procedure\ SQLServer_SpotLight-IndexLatchWaits.xml
Diagnostic Server by default is C:\Program Files\Dell\Diagnostic Server
AND
{Diagnostic Server installation folder}t\conf\Package\sqlserver_spotlight\2005\QS_IndexLatchWaitTimes.sql
2. Replace these files with the attached ones in their appropriate folders.
3. Acknowledge all existing alarm errors
STATUS:
Waiting for future release of Spotlight on SQL Server Enterprise.
Defect ID

SOSSE-6061
Attachments

SQLServer_SpotLight-IndexLatchWaits
QS_IndexLatchWaitTimes

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title