SQL Server Performance Troubleshooting - How best tools can help & techniques?
In this session I'm covering the End-To-End track of how to detect, diagnose, and resolve performance problems in SQL Server (not a difficult job). Be aware that it may take few month to know about tools that can be used to monitor the performance, but it may take years of on-the-job experience to learn how 'best' to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.
The talk details and demonstrates native tools and techniques that can make your long days shorter and make difficult troubleshooting activities much faster and easier. This is not only for a DBA, every SQL Server user needs to know how to keep their database platform in pristine condition, and you'll need these skills to do it.
Sorry, there are no downloads available for this session.
Knowledge is the power and you will gain by sharing it;
SQL Server MVP and Subject Matter Expert with consulting & technical expertise for Databases, Business Intelligence & Architecture solutions with over 23+ years of experience. My work experience inclduesa wide range of industries, including the stock exchange, insurance, tele-communications, financial, retail, and manufacturing sectors, among others.
A regular Speaker and SME volunteer at major technology conferences such as Microsoft Tech-Ed (Europe, India and North America), SQL PASS (Europe and North America), SQL Bits – UK and manages Scottish Area SQL Server user group based in Scotland. A moderator in majority of web based SQL Server forums (Microsoft Technet & www.sql-server-performance.com), writer, contributing editor & blogs at www.sqlserver-qa.net, www.sql-server-performance.com and www.beyondrelational.com websites.
Author of Microsoft SQL Server 2008 R2 Administration cookbook (released May 2011) - www.packtpub.com
Author - Microsoft SQL Server 2012 Analysis Services Cube Security How-to - www.packtpub.com
Co-Author of MVP Deep Dives SQL Server Volume II from Manning Publications.
The video is not available to view online.