469,106 Members | 2,148 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

does sql server collect stats on full table scans?

Hi all. Anyone know if sql server collects stats on how many full
table scans a table gets and if so how do I get at those stats? Trying
to track down poorly indexed tables / processes and I am guessing that
sql server does have this data secreted away somewhere much like my
db2 and informix databases do.
Jul 20 '05 #1
1 2554
On 20 Oct 2004 06:41:51 -0700, sumGirl wrote:
Hi all. Anyone know if sql server collects stats on how many full
table scans a table gets and if so how do I get at those stats? Trying
to track down poorly indexed tables / processes and I am guessing that
sql server does have this data secreted away somewhere much like my
db2 and informix databases do.


There is a performance counter under the "SQL Server:Access Methods"
category called "Full Scans/sec". Unfortunately nothing cumulative as far
as I can see. You could do a trace against your database, set an alert for
Full Scans/sec > 0 and see what was happening at that time.
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Fred Pacquier | last post: by
reply views Thread by Carlos Ibarra | last post: by
22 posts views Thread by Joseph Shraibman | last post: by
9 posts views Thread by Frank Rizzo | last post: by
1 post views Thread by MKoool | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.