Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

How to convince people for small changes Expand / Collapse
Author
Message
Posted Friday, May 17, 2013 1:11 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 5:20 AM
Points: 3,546, Visits: 2,651
GilaMonster (5/13/2013)
sqlnaive (5/13/2013)
One more thing, even if these indexes are getting used, the stats from dmv sys.dm_db_index_usage_stats says that index_seek+index_scan_index_lookups are almost none as compared to index_write. The question here is also that should we consider these stats or not ?


Depends how long you've tracked those stats for. They're not persistent.


Thanks Gail as always. These details are from quite long. So I'm considering performing the action based on these stats.
Post #1453871
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse