Posted By

tvanzele on 04/17/10


sql DMV

Versions (?)

Who likes this?

1 person have marked this snippet as a favorite


Index Read/Write/Fill Factor stats (current DB)

 / Published in: SQL

  1. SELECT OBJECT_NAME(s.[object_id]) AS [ObjectName], AS [IndexName], i.index_id,user_seeks + user_scans + user_lookups AS [Reads], user_updates AS [Writes],i.type_desc AS [IndexType], i.fill_factor AS [FillFactor]
  2. FROM sys.dm_db_index_usage_stats AS s
  3. INNER JOIN sys.indexes AS i
  4. ON s.[object_id] = i.[object_id]
  5. WHERE OBJECTPROPERTY(s.[object_id],'IsUserTable') = 1
  6. AND i.index_id = s.index_id
  7. AND s.database_id = DB_ID()
  8. ORDER BY OBJECT_NAME(s.[object_id]), writes DESC, reads DESC;

Report this snippet  


RSS Icon Subscribe to comments
Posted By: on February 7, 2019

download best software to android root use app kingo or 360 for pc mac ios windows 10 8 1 7 xp computer nzle

You need to login to post a comment.