Ten tips for proactive SQL Server performance monitoring - Part 1

learn practical tips for proactively monitoring and managing SQL Server performance. In this series, we will demonstrate how to:

1. Find blocking and locking issues
2. Pin-point long running queries
3. Identify query performance trends that could spell trouble
4. Find and fix index fragmentation
5. Monitor key resource consumption metrics, like CPU and I/O
6. Monitor windows server performance counters and custom counters
7. Review job histories and backup completion
8. Monitor database size and trends
9. Review key database and server configuration settings
10. Execute real-time traces on SPID/Processes and kill processes