Some of the historical reports take too long to generate
From DocWiki
(Difference between revisions)
Pshree (Talk | contribs)
(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...)
Newer edit →
(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...)
Newer edit →
Revision as of 04:21, 14 June 2010
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 # |
