Kunal RanpuraAug 12, 20191 minSQL Server Index Read/Write stats (all tables in current DB) ordered by WritesSELECT OBJECT_NAME(s.[object_id]) AS [ObjectName], i.name AS [IndexName], i.index_id, s.user_updates AS [Writes], user_seeks + user_scans...
Kunal RanpuraAug 12, 20191 minSQL Server Index Read/Write stats (all tables in current DB) ordered by ReadsSELECT OBJECT_NAME(s.[object_id]) AS [ObjectName], i.name AS [IndexName], i.index_id, user_seeks + user_scans + user_lookups AS [Reads],...
Kunal RanpuraAug 12, 20191 minSQL Server missing indexes from cached plans in the current database-- Find missing index warnings for cached plans in the current database -- Note: This query could take some time on a busy instance...
Kunal RanpuraAug 12, 20191 minSQL Server Missing Indexes current database by Index AdvantageSELECT user_seeks * avg_total_user_cost * (avg_user_impact * 0.01) AS [index_advantage], migs.last_user_seek, mid.[statement] AS...