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)

Level: Intermediate to Advanced (Level 200 to 300)

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): $249 USD (Add all three Fast-Track Courses in the cart and apply code: HAPPY2021. 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

23 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. 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

  8. Eric June 22, 2020 at 1:13 pm - Reply

    An extremely informative, detailed, very well explained and thoughtfully structured course. Thanks, Amit, for the knowledge share.

  9. kenneth July 9, 2020 at 10:05 am - Reply

    Well organized and good content. Overall, this course is full of labs, demos, real-time examples of a lot of important concepts. Highly recommend the course.

  10. Bianca August 9, 2020 at 1:00 am - Reply

    Easy to understand the explanations and we can watch the videos as many times as we want if we are stuck with any concept. The instructor was great, explained every little topic in detail.

  11. Saikiran October 11, 2020 at 5:09 pm - Reply

    Quite worthy to subscribe to the Video Course. Valuable information.

  12. Flemming December 11, 2020 at 2:59 am - Reply

    This is an exceptional course on SQL Server Performance Tuning. Showed multiple ways how to troubleshoot in real world. Full of demos and scripts. Learned a lot in a short span.

  13. Paul January 26, 2021 at 6:21 am - Reply

    This course is a good one. It’s all about SQL Server performance tuning. It shows relevant query tuning techniques that will solve many performance issues. I enjoyed doing this course and would definitely recommend it.

  14. David February 22, 2021 at 10:17 am - Reply

    It’s a wonderful course and to the point, he teaches very calmly and concepts are easily comprehensible. I have gained lot of confidence on myself and eagerly waiting for Query Tuning course.

  15. Yuri March 22, 2021 at 10:06 am - Reply

    The instructor had a high knowledge and he created a pleasant format of learning. Thanks.

  16. komal bhos March 22, 2021 at 11:57 am - Reply

    Hi,I want this video course Please let me know what is fees ?

    • SQLMaestros Admin March 22, 2021 at 3:14 pm - Reply

      Hi Komal,
      Thanks for showing interest in SQLMaestros Video Courses. Course outline and pricing have been mentioned along with each course.
      In case, there is a need for any clarification, pls feel free to drop an email to contact[at]sqlmaestros[dot]com.

  17. Jose May 2, 2021 at 11:11 am - Reply

    Excellent Video quality. Would definitely recommend this course. Also, looking forward for more such demo filled courses on Query Tuning and Index Tuning.

  18. Adel June 10, 2021 at 1:04 am - Reply

    Learnt a lot, very happy that Amit along with the knowledge shared has provided all the scripts/syntax as needed. They will always come very handy. Thanks Amit Bansal

  19. Ryan July 9, 2021 at 12:26 pm - Reply

    Video is well made, has agenda, introductions, theory and practice demos instructed by Amit Bansal. Great course.

  20. Steve July 9, 2021 at 12:47 pm - Reply

    The course is a good introduction from basic concepts to more advanced tuning examples. My first subscription with SQLMaestros Video Courses and I wish to subscribe for the other two also. I liked doing this course and would recommend to go for it.

  21. Ram Kumar July 15, 2021 at 3:00 pm - Reply

    where can we get SQLMaestros database used in “Understand Views in SQL Server ” session ?

Leave A Comment