PRACTICAL SQL SERVER PERFORMANCE TUNING CLASS

Singapore SQL PASS Chapter, Gill Technologies

Speaker Bio:
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 & SQL Saturday events. 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, visit http://sqlmaestros.com/amit-bansal/
 
Session Abstract
SQL Server Performance Tuning Pre-Con is designed for the working SQL Server professionals, Developers, Database Administrators & Architects who have relevant experience with SQL Server and only needs practical examples of performance tuning that can be applied in applications & production right away. In this full-day training, participants will see relevant, crisp, real-world examples of tuning SQL Server performance.
 An 8-hour, 100% demo-oriented delivery on SQL Server Performance Tuning. Basic to Intermediate level, covering important aspects.
 Module 1: SQL Server Wait Types & Statistics
Query Lifecycle
Connections -> Sessions -> Requests -> Tasks -> Workers -> Threads
Common Wait Types in SQL Server, identification & diagnosis
 Module 2: The Holy Trinity – CPU, Memory, IO
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
 Module 3: Query Execution & Query Plan Analysis
Statistics & Cardinality Estimation
Reading & Analysing Execution Plans
Important Iterators 
 Module 4: Query Tuning
Rewriting Transact-SQL
Optimizing Stored Procedures
Solving Parameter Sniffing Issues
Parametrization Best Practices 
Tips with Procedural Code
 Module 5: Index Tuning
Demystifying Common Myths with Indexes
Indexing Strategies
Index Fragmentation
Real-World Index Tuning Examples
 Module 6: Dealing with Deadlocks
SQL Server Concurrency, Isolation Levels, Locking Granularity & Hierarchy 
Common Deadlock Types
Deadlock Best Practices
Practical Deadlock Troubleshooting & Diagnosis
 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, lack real-world examples. In this pre-con, an attendee will learn real world performance tuning skills with SQL Server. I am emphasizing on real-world & practical skills.
Pre-Con will be fast paced. 100% Demo-oriented. Attendees are requested to pay full attention to the instructor and the demos.
Laptops & mobile phones off. All demo codes & labs will be provided to practice later.

PRACTICAL SQL SERVER PERFORMANCE TUNING CLASS

More events from Singapore SQL PASS Chapter, Gill Technologies

Discover more events from Singapore SQL PASS Chapter, Gill Technologies, from Science & Tech to other experiences you might love.

Still looking for the right event?

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

PRACTICAL SQL SERVER PERFORMANCE TUNING CLASS

More events from Singapore SQL PASS Chapter, Gill Technologies

Discover more events from Singapore SQL PASS Chapter, Gill Technologies, 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 Singapore and filter by date, category, and more to find the perfect fit.