Background and Symptom
The ESM MS SQL databases may, under certain conditions and after a long period of heavy use, develop fragmented database indexes. These fragmented indexes can slow a variety of operations, eventually causing errors that report the following message in the Windows Event Log:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Operations which may be affected by this error include: adding or removing cameras, adding or removing users, and missing recorded video from multiple cameras (which will also create a notification on the ESM Alarms page).
Corrective Action
- Open SQL Server Management Studio.
- Connect to the ESM management server (which hosts the ESM5_2_Central database).
- Execute the following SQL commands:
USE ESM5_2_CentralGOsp_msforeachtable "PRINT '?'; ALTER INDEX ALL ON ? REBUILD WITH (FILLFACTOR = 80)"
The query should be executed successfully. - Connect to each ESM archive server (each of which host a separate ESM5_2 database).
- For each archive server, execute the following SQL command:
USE ESM5_2GOsp_msforeachtable "PRINT '?'; ALTER INDEX ALL ON ? REBUILD WITH (FILLFACTOR = 80)"
The query should be executed successfully.
Comments
0 comments
Please sign in to leave a comment.