Do you wish to continue getting SQL content from us? If yes, please subscribe to our new list.
Hi There,
SQLMaestros Master Class on SQL Server Performance Tuning – Fast Track (Online) is coming up this week (21/22 July). Join this demo-filled, 8-hour class (4 hours per day), where you will learn the three approaches of SQL Server performance troubleshooting & tuning – Proactive, Real-time & Reactive. You will learn the practical way, exactly like how you would troubleshoot in the real world with lots of code and scripts.
Modules:
1: Core Concepts
Query Lifecycle
Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads
Common Wait Types in SQL Server, identification & diagnosis
2: The Foursome – CPU, Memory, IO & Tempdb
Identifying, troubleshooting & tuning workload patterns that cause excessive CPU
Identifying, troubleshooting & tuning workload patterns that cause excessive Memory Usage
Identifying, troubleshooting & tuning workload patterns that cause excessive IO
Identifying, troubleshooting & tuning workload patterns that cause excessive Tempdb usage
3: Query Execution & Query Plan Analysis
Statistics & Cardinality Estimation
Reading & Analysing Execution Plans
Important Iterators
4: Index Tuning
Demystifying Common Myths with Indexes
Indexing Strategies
Index Fragmentation
Real-World Index Tuning Examples
5: Query Tuning
Rewriting Transact-SQL
Dealing with Implicit Conversions
Sargability
Solving Parameter Sniffing Issues
Parametrization Best Practices
6: Dealing with Deadlocks
Common Deadlock Types
Deadlock Best Practices
Practical Deadlock Troubleshooting & Diagnosis
Book your seat today. Learn More.
If you want to learn at your own pace, explore these video courses. With the Performance Tuning course, you are getting Querying & Programming courses complimentary. Subscribe today.
Not interested in paid courses & classes? No worries, there is a free webinar on Execution Plans coming up on July 20.
Check out and reserve your spot.
Blog/Video of the day: Reading the same record twice. Interesting stuff. Check out.
Stay tuned, more SQL content coming your way.
With Warm Regards
SQLMaestros Team – Join us on LinkedIn
Do you wish to continue getting SQL content from us? If yes, please subscribe to our new list.
Subscribe to SQLMaestros Newsletter | Access Past Newsletters
Leave A Comment