Troubleshooting challenging performance issues using SQL Server DMVs

For November the Charlotte SQL Server Users Group is pleased to feature a presentation from our fellow member Sergey Pustovit on "Troubleshooting challenging performance issues using SQL Server DMVs."

There are number of tools available on the market for the SQL Server performance troubleshooting. But do we use the full power of the internal SQL Server Data Management Views (DMVs)? Some very challenging issues can be solved using DMVs. What the Dynamic Management Views are? How diagnostics data is getting populated? Using the examples we are going to talk about diagnostic data analysis using T-SQL queries against SQL Server DMVs.

Speaker's Bio:

Sergey Pustovit is a SQL Escalation Engineer for Microsoft working in the Charlotte offices. As member of SQL Server Escalation Services, Sergey works on most challenging technical issues, interacts closely with the SQL Development team working on problem resolutions and providing product feedback. He has 15 years of industry experience, working with distributed database systems, designing and developing business solutions for the financial industry.

Agenda:

5:30 PM Networking and Pizza

6:15 PM Presentation

7:40 PM Meeting end

The meeting is being held at the Microsoft Offices. Enter the building on the right at the first entrance and ask for the Mt Everest / Mt Kilimanjar rooms.