Some of the historical reports take too long to generate

From DocWiki

(Difference between revisions)
Jump to: navigation, search
(New page: == Some of the historical reports take too long to generate == {| border="1" |- ! '''Problem Summary''' | Some of the historical reports take too long to generate even if we run the query...)
m (1 revision)
 

Latest revision as of 06:31, 8 July 2011

Some of the historical reports take too long to generate

Problem Summary Some of the historical reports take too long to generate even if we run the query directly on server
Error Message
Possible Cause Database statistics have not been updated for long or indexing of tables is not proper
Recommended Action Execute the following query on both the nodes to update statistics for all tables
Use db_cra
GO
exec sp_updatestats
GO

If this did not resolve the issue, try reindexing the tables using the following script

USE db_cra
GO
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
GO
EXEC sp_updatestats
GO 
Release 7.0
Associated CDETS #

Rating: 0.0/5 (0 votes cast)

Personal tools