Today I had the pleasure of speaking at the inaugural SQL Saturday event in Detroit, MI. I spoke on one of my favorite topics, Database Health and Performance. I had a great time speaking to a packed room, and kudos goes to the coordinators and volunteers. You all did a fantastic job on your first SQL Saturday, and I look forward to seeing you next year!
Here is the session abstract that I presented today.
Sure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? In an emergency, can you objectively demonstrate where a performance problem lies? This dynamic dialog session will present a solid process for checking your environment’s overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.
Session Level: Intermediate