Hi I have three SQL 2008 R2 Servers each being monitored with Spotlight Enterprise 11.7.1 and I am seeing this error only on one of the servers and I was wondering if this was a bug or if there was something not configured correctly?
The popup box has the following Collection by Fragmentation Index Failed: The SQL query has been executing for longer than it’s timeout limit but has not timed out. It maybe hung. No alarms currently raised.
When I go into the database and select the fragmented indexes this is the error I receive:
Component: Fragmented Indexes
The following error occurred while collecting data
The SQL query has been executing for longer than its timeout limit but has not timed out. It may be hung. [Error Code: 13].
Table: Fragmentation by Index
Occurred: 5/4/2017 10:22:30 AM
I appreciate any help or direction as I am new to Spotlight and I have walked through all 3 servers and all are configured the same for Spotlight.