How to find index usage in Sql Server

  SELECT OBJECT_NAME(ddius.[object_id], ddius.database_id) AS [object_name] , ddius.index_id , ddius.user_seeks , ddius.user_scans , ddius.user_lookups , ddius.user_seeks + ddius.user_scans + ddius.user_lookups

Continue reading

ALL DMV’s In SQL SERVER

SELECT * FROM SYS.dm_os_memory_allocations               –<< Notice that all DMVs starts with SYS.DM SELECT * FROM SYS.dm_db_xtp_nonclustered_index_stats   SELECT * FROM SYS.dm_db_mirroring_past_actions

Continue reading