Welcome to Aussie SQL Server Bloggers
Sign in
|
Join
|
Help
Transaction blog
This Blog
Email
Calendar
Mar
April 2008
May
M
T
W
T
F
S
S
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
4
5
6
7
8
9
10
11
Search
Go
Syndication
RSS 2.0
Atom 1.0
Archives
April 2008 (4)
February 2008 (2)
January 2008 (1)
June 2007 (2)
April 2007 (4)
March 2007 (1)
December 2006 (6)
November 2006 (2)
October 2006 (1)
September 2006 (13)
August 2006 (2)
July 2006 (1)
June 2006 (2)
May 2006 (1)
April 2006 (3)
March 2006 (11)
February 2006 (3)
January 2006 (2)
November 2005 (1)
October 2005 (1)
September 2005 (1)
April 2005 (1)
March 2005 (2)
February 2005 (3)
December 2004 (5)
November 2004 (3)
October 2004 (1)
September 2004 (2)
Navigation
Home
Blogs
Photos
Post Categories
Australian SQL Server User Group (4)
Personal stuff (6)
SQL Server - other (6)
SQL Server - Scripts (9)
SQL Server - Technical (19)
Sunday, 27 April 2008 - Posts
Sunday, 27 April 2008 9:05 PM
Which query is scanning that index?
SQL 2005's db_dm_index_usage_stats DMV allows DBAs to analyse how often indexes are being used (or not used), including individual counts for seeks, scans & lookups on each index in your database. I was thrilled when I first saw this DMV as there
posted by
Greg_Linwood
|
4 Comments
Filed Under:
SQL Server - Scripts
,
SQL Server - Technical