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 (Lifetime Access)
Best Deal: Get all three Fast-Track Courses in $249 USD (Add all three Fast-Track Courses in the cart and apply code: HAPPY2021. It’s a STEAL. Limited Period Only. Lifetime Access.)
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
Sample Content
Why ‘SQL Server Performance Tuning – Fast Track’ Video Course
Important Links
FAQs | |
Corporate Subscription | |
Testimonials (Across The Globe) | |
Corporate Feedback | |
LinkedIn Recommendations | |
About Amit Bansal | |
Amit Bansal’s Profile | |
Why Amit Bansal? | |
Why Video Course | |
Terms of Use |
Social Media Links, Our Forums & Free Learning Resources
Free Videos | |
LinkedIn Page | |
LinkedIn Group | |
Facebook Page | |
Telegram Forum |
Other Learning Solutions
Hands-On-Labs Learning Solution | |
More Video Courses | |
Learning Kits | |
Electronic Books (PDFs) |
More Testimonials
Microsoft made a beautiful illustration of Amit Bansal’s original pic. Thanks Microsoft for all the encouragement.
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.
Hi,
Would you please inform if SQL SERVER video courses are available.
Best Regards
khalil
Please let me know when SQL Server video courses are available.
Thanks,
SV…
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
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
Please let me know what is fees and when are you uploading those videos.
Thanks
Siva
Hi Team,
Eagerly waiting for Video courses.Please advise when they will be available
Thanks and Regards,
Jagadish Parale
An extremely informative, detailed, very well explained and thoughtfully structured course. Thanks, Amit, for the knowledge share.
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.
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.
Quite worthy to subscribe to the Video Course. Valuable information.
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.
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.
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.
The instructor had a high knowledge and he created a pleasant format of learning. Thanks.
Hi,I want this video course Please let me know what is fees ?
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.
Excellent Video quality. Would definitely recommend this course. Also, looking forward for more such demo filled courses on Query Tuning and Index Tuning.
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
Hi,
if i purchase the “SQL Server Performance Tuning – Fast Track” then it contains all hands-On-Labs with this video course. Please confirm. Also, There is a offer for VC to get 100% OFF on the Querying & Programming Videos Courses.
Hi,
If “Hands-On-Labs” is not part of the video course then will get an additional offer on “hands-On-Labs”? kindly confirm.
Video is well made, has agenda, introductions, theory and practice demos instructed by Amit Bansal. Great course.
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.
where can we get SQLMaestros database used in “Understand Views in SQL Server ” session ?
Thank you for checking. Can be downloaded from here: https://sqlmaestros.com/mc-sample-databases/
I am looking for complete performance tuning course , is this the bundle or do we need to do some other .