Tonights Topic: Schedule Collisions and the Effect on SQL Server Performance
Heavy contention for disk resources can dramatically impact SQL Server performance, and SQL Server Agent jobs can be some of the biggest offenders. In this presentation, Steve Wright, MCSD, MCDBA from the sqlSentry Support Team will cover:
How and why jobs and job collisions can cause disk contention,
How to isolate the sources of disk contention using Windows performance counters
and analyze the data using some simple formulas, and
How to reduce contention in general via "leveling" your job schedules
I met Cihan Biyikoglu from Microsoft's SQL Team at the Financial Developer event earlier this week and I invited him to the meeting. He's excited about meeting members of the NY SQL community.