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.



Presented by Satya Jayanty at SQLBits VI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    satya_jayanty.jpg
    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.
    http://sqlserver-qa.net/blogs/Bloggers.aspx http://sqlserver-qa.net/blogs/MainFeed.aspx
  • Video
    The video is not available to view online.