NZ$157.46 – NZ$262.06

SQL Server Performance Tuning for DBAs

Event Information

Share this event

Date and Time

Location

Location

TBC

Wellington, 6001

New Zealand

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

Amit Bansal presents "SQL Server Performance Tuning for DBAs" Pre-Con

‘SQL Server Performance Tuning for DBAs’ Pre-Con is designed for the working SQL Server DBA 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 areas related to performance tuning. 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

Note: These will be paid events and note also that as we are a small not-for-profit association we are not GST registered and therefore do not issue Tax Receipts for these registrations.

About Amit Bansal

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 Data Platform Summit (India), MS Ignite (US), SQLBits (UK), PASS Summit (US) & SQL Saturday events across the globe.

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. His videos are available on www.youtube.com/SQLMaestros.

To learn more about Amit, visit http://sqlmaestros.com/amit-bansal/

Share with friends

Date and Time

Location

TBC

Wellington, 6001

New Zealand

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved