Practical SQL Server Performance Tuning

Amit R S Bansal is a SQL Server Specialist at SQLMaestros (brand of eDominer Systems).He leads the SQL and BI practice with a much focused team providing consulting, training and content development services to more than 160+ SQL customers globally.He frequently speaks at international conferences including MS Ignite, SQLBits, SSGAS/DPS, PASS Summit. Amit is also honored with Microsoft Regional Director status, MVP award and Microsoft Certified Master of SQL Server credential. Amit has been working with SQL Server since 1999 and has been part of countless mission critical SQL deployments. Performance Tuning in SQL Server is his core area of expertise.To learn more about Amit, visithttp://sqlmaestros.com/amit-bansal/

Amit R S Bansal

Practical Performance Troubleshooting Pre-Con is designed for the working SQL Server professional who has the relevant experience with SQL Server and only needs practical examples of troubleshooting SQL Server performance that can be applied in production right away. In this full-day training, participants will see relevant, crisp, real-world examples of common performance areas.
 An 8-hour, 100% demo-oriented delivery on SQL Server Performance Troubleshooting. Basic to Intermediate level, covering important aspects.
 Module 1: CPU Troubleshooting (Scheduling)
Query Lifecycle
Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads
Common Scheduler Wait Types in SQL Server, identification & diagnosis
CPU Performance Troubleshooting
Identifying workload patterns that cause excessive CPU
Important DMVs & Performance Counters
 
Module 2: IO Troubleshooting
Understanding SQL Server IO patterns
Troubleshooting IO bottlenecks using DMVs
Troubleshooting IO bottlenecks using Performance Counters
Troubleshooting IO bottlenecks using Wait Types
Identifying workloads that cause excessive IO
 
Module 3: Memory Troubleshooting
SQL Server Memory Architecture – Welcome To The Dungeon
Internal vs External Memory Pressure
Understanding Memory Errors
Troubleshooting Memory Issues
Identifying workloads that cause excessive memory usage
Memory Wait Types
Understanding Query Workspace Memory
 
Module 4: Tempdb Troubleshooting
Common issues with Tempdb and resolutions
Identifying workloads that cause maximum Tempdb usage
Tips/Tricks with Tempdb to improve performance
 
Module 5: Dealing with Deadlocks
Common Deadlock Types
Deadlock Best Practices
Practical Deadlock Troubleshooting & Diagnosis
 
Module 6: Troubleshooting Indexes
Demystifying Common Myths with Indexes
Indexing Strategies
Real-World Index Tuning Examples
 
Pre-Con Takeaways:
Practical, Real-World Examples
All Demo Scripts
Loads of learning that can be applied into production right-away
 
Additional Notes
Most training programs, theoretical or practical, lac real-world examples. In this pre-con, an attendee will learn real world performance troubleshooting skills with SQL Server. I am emphasizing on real-world & practical skills.

Practical SQL Server Performance Tuning

More events from Amit R S Bansal

Discover more events from Amit R S Bansal, from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all events in Christchurch and filter by date, category, and more to find the perfect fit.

Practical SQL Server Performance Tuning

More events from Amit R S Bansal

Discover more events from Amit R S Bansal, from Science & Tech to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in Christchurch and filter by date, category, and more to find the perfect fit.