From: Daniel NichitoaeSent: Tuesday, May 21, 2019 3:17 PM
Subject: Case # 72041 - ScanDox: After applying annotation, and then performing send to ScanDox, re-submission times out with error
Mark,
Based on the error message (a SQL timeout) and your results when you ran the query manually (also a SQL timeout) it looks like the database is not a very good shape.
Have you had a chance to check the size of the database transaction log? If not can you please check? Also can you please run the query below and send me back the result?
--Query to run against the isynergy database
SELECT DB_NAME(PS.database_id) AS dbName,
S.name AS SchemaName,
O.name AS TableName,
b.name,
ps.avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS ps
INNER JOIN sys.indexes AS b ON ps.OBJECT_ID = b.OBJECT_ID AND ps.index_id = b.index_id
INNER JOIN sys.objects O ON PS.object_id = O.object_id
INNER JOIN sys.schemas S ON S.schema_id = O.schema_id
WHERE ps.avg_fragmentation_in_percent >= 20 -- Indexes having Fragmentation >=20
AND PS.index_type_desc IN ('CLUSTERED INDEX','NONCLUSTERED INDEX') -- Only get clustered and nonclustered indexes
AND b.is_hypothetical = 0 -- Only real indexes
AND O.type_desc = 'USER_TABLE' -- Restrict to user tables
AND PS.page_count > 8 --- ignore tables less tha 64K
ORDER BY ps.avg_fragmentation_in_percent DESC