Currently Browsing: SQL Monitoring

SQL Server / Index Usage Report Project

SQL Server / Index Usage Report Project
 Index Usage Report Project   The general project idea was to create the report about every index usage within DB. To be able to see a daily number of scans, seeks, page splits for all indexes or key lookups for clustered. You also can change the date range to see how this index behaved in past.     Also, to be able to see all expensive queries using that index (red one are expensive).     To see and save their execution plans as well.       Project concept   Index Usage Stats system views [sys].[indexes] – Basic index information (name, type, etc)...
read more

Next Entries »