data-konzept

'Every DBA squirrels away favourite queries for monitoring SQL Server. Nowadays many of these are too complex to keep in your head. Dennes describes how he uses T-SQL queries for solving problems, whether it involves fixing the problems of missing indexes, preventing unrestrained autogrowth, avoiding index fragmentation, checking whether jobs have failed  or avoiding memory stress conditions.'...

https://www.simple-talk.com/sql/database-administration/5-monitoring-queries-for-sql-server/