downloads > white papers >

Unusually heavy contention for disk resources can dramatically impact SQL Server performance.

SQL Sentry Event Manager makes it a simple matter to see exactly what role jobs are playing in this issue. Many types of jobs are some of the biggest offenders since they incur disk IO's outside of the SQL Server process space, meaning SQL Server isn't in direct control of prioritizing all of the reads and writes. This includes database and transaction log backups to disk, scheduled import/export (ETL) processes using DTS or BCP, or any other jobs that read and write large amounts of data to or from disk.

If those jobs are hitting the same physical disk resources used by your database files (data/index or trans log files), it can cause performance problems for end users accessing those databases. Without warning application queries may take 2-3 times longer than normal, or even worse buffer latch timeout errors can occur. You can also experience a dramatically shortened lifespan for your disk resources.

 Download the white paper

 Video: Event Manager Overview