| Author |
SQL Server statistics
|
|
| Praveen 2006-03-10, 3:23 am |
| How do i find out sql server statistics are out of date for particular
table or index?.
(Except Graphical excution plan and profiler). is there any system
procedure avilible?.
| |
| Roji. P. Thomas 2006-03-10, 3:23 am |
| DBCC SHOW_STATISTICS
--
Regards
Roji. P. Thomas
http://toponewithties.blogspot.com
"Praveen" <apveen@gmail.com> wrote in message
news:1141971917.083529.179880@i40g2000cwc.googlegroups.com...
> How do i find out sql server statistics are out of date for particular
> table or index?.
> (Except Graphical excution plan and profiler). is there any system
> procedure avilible?.
>
| |
| Praveen 2006-03-10, 3:23 am |
| How can i find out the particular statistics becomes out of date based
on this DBCC SHOW_STATISTICS result?.
| |
|
|
| Praveen 2006-03-10, 3:23 am |
| How can i find out the particular statistics become old?. i.e
statistics not proper or old?.
| |
| Tibor Karaszi 2006-03-10, 3:23 am |
| DBCC SHOW_STATIATICS will tell you when you last updated the statistics. If you need to check the
information stored in the statistics compared to the actual values in the table you have to compare
the output from DBCC SHOW_STATISTICS to what you physically have in the table. Or you can also read
in Books Online about the rowmodctr column in the sysindexes table.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"Praveen" <apveen@gmail.com> wrote in message
news:1141981513.273371.142260@i40g2000cwc.googlegroups.com...
> How can i find out the particular statistics become old?. i.e
> statistics not proper or old?.
>
|
|
|
|