DBA vs. Overabundance: Where to start troubleshooting?
With features ranging from replication to always on availability groups,constantly expanding to include everything from StreamInsight to Hadoop, the life of a SQL Server DBA while exciting and interesting is now so feature rich it can be overwhelming at times. This can be even more challenging when it comes to troubleshooting.
To complement all the new features the DBA now has a growing suite of tools to choose from. Everything from new perfmon counters to changing DMV's; profiler trace deprecation to extended events,with so much diagnostics data available it is sometimes hard to know the best tool for the job.
In this presentation I will show you the methodology I use of breaking down SQL Server into its simplest components giving you the knowledge required to choose the required tool for the situation regardless of the feature.
Sorry, there are no downloads available for this session.
Tony O'Grady works at Microsoft UK as a Dedicated Support Engineer for SQL Server. Currently focused on working side-by-side with premier customers improving system health and deepening our understating of the product.
The video is not available to view online.