$150 – $200

PRACTICAL SQL SERVER PERFORMANCE TUNING CLASS

Event Information

Share this event

Date and Time

Location

Location

Microsoft Singapore

Level 22, CF - 15

one marina boulevard

Singapore, 018989

Singapore

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

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.


Share with friends

Date and Time

Location

Microsoft Singapore

Level 22, CF - 15

one marina boulevard

Singapore, 018989

Singapore

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved