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