SQL Server Performance Tuning – Fast Track

One fine day you realize that you have to start tuning SQL Server for better performance. The need might have arisen from a recent performance issue, or the barrage of support tickets that are filling your inbox, or maybe your boss assigned this to you after realizing that SQL Server performance troubleshooting is not his cup of tea. Irrespective of the reason, the challenge is upon you to identify, diagnose and fix a variety of performance issue that is plaguing your SQL Server environment.

Performance troubleshooting can be categorized as proactive, real-time & reactive. If a well-defined methodology is followed during the proactive phase, you will have to fire-fight less during the real-time troubleshooting phase and you will have a lot of meaningful performance data to work within the reactive phase, which will further help you in preventing performance cases.

Subscribe to this demo-packed video course, where you will learn the three approaches of SQL Server performance troubleshooting & tuning. You will learn the practical way, exactly like how you would troubleshoot in the real world with lots of code and scripts. Amongst many takeaways, here are some interesting ones:

  • Develop a performance troubleshooting methodology for the real-world
  • Analyzing and troubleshooting common wait types
  • Proactive, reactive and real-time CPU troubleshooting
  • Troubleshooting IO performance bottlenecks
  • Tracking SQL Server memory consumption and fixing OOM errors
  • Dealing with Tempdb madness
  • Top six query tuning techniques that will solve 75% of performance issues (real-world query tuning)
  • Top six indexing strategies that will fix 60% indexing woes
  • Get rid of deadlocks (yes, you hear it right)
  • SQL Server 2019 performance enhancements

In total, there will be six modules comprising of close to 50 demos, all from the real-world. Yes, a lot of content and well-paced. You will get all the demo scripts, most of them being production-ready. You will also get PDF version of the content.

Please note that from the website here, you can only make an individual subscription. For team/corporate subscription (for a group of people), please Click Here.
Read Terms of Use
.

Instructor: Amit R S Bansal

Total Duration: 15 hours 12 Mins

Total Lecture Time: 5 hrs 43 mins

Total Demo Time: 9 hrs 29 mins (Yeah, demos are the real value)

Delivery Format: Video Course. Stream anywhere, anytime, any device, as many times.

Pre-Requisite: You need to have at least one year of genuine SQL Server experience to gain maximum from this course

Course Outline & Duration Breakup – View Online | Download

Pricing, Discounts & Bundles

Regular Price: $699 USD (Yearly Subscription)

Discounted Price: $249 USD (Yearly Subscription)

Best Deal: All-In-One Bundle Price (Fast-Track): $449 USD (Add all three Fast-Track Courses in the cart and get a bundle price of $449. It’s a STEAL. Limited Period Only. Yearly Subscription)

Note: Discounts are offered to support the SQL community during these tough times.

Subscribe

Start Watching

Corporate Licensing

 
 
 

Course Outline

Module 0: Introduction

  • Before You Begin
  • Modules
  • Demo Setup
  • What Not To Expect
  • What To Expect
  • How To Get The Best Out Of This Course

Module 1: Performance Troubleshooting Methodology

  • Where Shall I Begin?
  • An Ocean Within An Ocean
  • Installation & Configuration Best Practices
  • Performance Monitoring, Benchmarking & Baselining
  • Developing a Performance Troubleshooting Methodology
  • Tools & Utilities
  • Demos
  • Summary

Module 2: Wait Statistics

  • Query Execution
  • Waiting & Queuing
  • Putting It Together
  • Working With Wait Stats
  • Common Wait Types
  • System Wait Types
  • PAGEIOLATCH Wait Type
  • CXPACKET Wait Type
  • ASYNC_NETWORK_IO Wait Type
  • RESOURCE_SEMAPHORE Wait Type
  • Demos
  • Summary

Module 3: The Awesome Foursome – CPU, Memory, IO, Tempdb

  • A Classic Example
  • CPU Troubleshooting
  • Memory Troubleshooting
  • IO Troubleshooting
  • Tempdb Troubleshooting
  • Demos
  • Summary

Module 4: Query Tuning

  • Understanding Execution Plan
  • Statistics & Cardinality Estimation
  • Query Tuning
    • The Bad Bookmark Lookups
    • Expensive Sorts
    • Implicit Conversion
    • Non-SARGability
    • Stale Statistics
    • Parameter Sniffing
    • Re-Writing T-SQL
  • Query Store (SQL 2016)
  • Automatic Query Tuning (SQL 2017)
  • Intelligent Query Processing (SQL 2017 & 2019)
  • Demos
  • Summary

Module 5: Index Tuning

  • Indexing Architecture
  • Index Fragmentation
  • Indexing Guidelines
  • Index Tuning
  • Identifying Missing Indexes
  • Identifying Unused Indexes
  • Demos
  • Summary

Module 6: Concurrency Troubleshooting

  • Data Modification & Concurrency Architecture
  • Isolation Levels
  • Troubleshooting Blocking
  • Best Practices
  • Troubleshooting Deadlocks
  • Best Practices
  • Demos
  • Summary

Module 7: Wrap Up

Why ‘SQL Server Performance Tuning – Fast Track’ Video Course


Important Links

FAQs

Click Here

Corporate Subscription

Click Here

Watch Samples

Click Here

Testimonials (Across The Globe)

Click Here

Corporate Feedback

Click Here

LinkedIn Recommendations

Click Here

About Amit Bansal

Click Here

Amit Bansal’s Profile

Click Here

Why Amit Bansal?

Click Here

Why Video Course

Click Here

Terms of Use

Click Here

 

Social Media Links, Our Forums & Free Learning Resources

Free Videos

Click Here

Twitter

Click Here

LinkedIn Page

Click Here

LinkedIn Group

Click Here

Facebook Page

Click Here

Telegram Forum

Click Here

 

Other Learning Solutions

Hands-On-Labs Learning Solution

Click Here

More Video Courses

Click Here

Learning Kits

Click Here

Electronic Books (PDFs)

Click Here

 

More Testimonials

T-SQL Querying Video Course

Microsoft made a beautiful illustration of Amit Bansal’s original pic. Thanks Microsoft for all the encouragement.


 

Subscribe

Start Watching

Corporate Licensing

9 Comments

  1. Vinod November 11, 2014 at 4:41 pm - Reply

    Hi Amit,
    nice to see a person from India to get MVP award for 8 times in a row. I believe, it is a record. I’m Vinod Mallolu, working as a DBA from past 8 years. I want to update my self. currently iam located in London, so I could not be able to join classes. please let me know the process and amount to get training videos.

  2. khalil February 2, 2015 at 10:16 am - Reply

    Hi,
    Would you please inform if SQL SERVER video courses are available.

    Best Regards

    khalil

  3. SV February 26, 2015 at 11:35 pm - Reply

    Please let me know when SQL Server video courses are available.
    Thanks,
    SV…

  4. Palanivelrajan September 30, 2015 at 7:40 am - Reply

    Dear Amit,

    I live in USA and looking online video course related SQL Performance Tuning and DBA.
    I hope you understand our problem and bring the course early.
    Please let me know what is fees and when are you uploading those videos.

    Thanks
    Palanivelrajan

  5. Shiva April 8, 2016 at 12:32 am - Reply

    Hi,
    are you providing Videos courses on SQL Server ,T-SQL and DW Designing? or Complete MSBI modules.

    Please let me know the details of the course if it available.

    Thanks,
    Siva

  6. shiva April 8, 2016 at 12:33 am - Reply

    Please let me know what is fees and when are you uploading those videos.

    Thanks

    Siva

  7. Nikhil Mittal January 18, 2017 at 2:01 am - Reply

    Hi I need sql server query tuning and execution plan understanding video tutorials. Please mail me details and sample video link.

  8. Jagadish July 19, 2018 at 7:02 pm - Reply

    Hi Team,

    Eagerly waiting for Video courses.Please advise when they will be available

    Thanks and Regards,
    Jagadish Parale

  9. Pradeep December 30, 2019 at 11:35 pm - Reply

    Please provide fee for full video course and 40 hours course

Leave A Comment