SQL Saturday NYC - Database Health and Performance
A talk by
About the Talk
August 17, 2013 5:00 AM
Microsoft Office, 1290 Avenue of the Americas, 6th Flr, New York, NY 10104.Microsoft Office, 1290 Avenue of the Americas, 6th Flr, New York, NY 10104.
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.