Selamlar Tek bir tablodaki indexlerin Read / Write durumlarını görmek için aşağıdaki scripti kullanabiliriz [code=sql] SELECT OBJECT_NAME(s.[object_id]) AS [TableName], i.name AS [IndexName], i.index_id, SUM(user_seeks) AS [User Seeks], SUM(user_scans) AS [User Scans], SUM(user_lookups)AS [User Lookups], SUM(user_seeks + user_scans + user_lookups)AS [Total Reads], SUM(user_updates) AS [Total Writes] FROM sys.dm_db_index_usage_stats AS s INNER JOIN sys.indexes AS i ON s.[object_id] = i.[object_id] AND i.index_id = s.index_id WHERE OBJECTPROPERTY(s.[object_id],'IsUserTable') = 1 AND s.database_id = DB_ID() AND OBJECT_NAME(s.[object_id]) = N'TabloAdi' GROUP BY OBJECT_NAME(s.[object_id]), i.name, i.index_id ORDER BY [Total Writes] DESC, [Total Reads] DESC OPTION (RECOMPILE); [/code]