This demo-oriented day-long workshop will answer the questions which DBAs and Developers often wonder about Performance Tuning and Query Optimization. There are some problems which have straight forward answers, but there are some problems which are often invisible or need attention without even a problem statement. This full-day workshop will be divided in these three major components:
1. Identifying common patterns and anti-patters for database performance tuning
- slow running queries
- IO Intensive operations
- CPU bottlenecks
- memory optimizations
- tempdb contention
- and much more
2. Resolving optimization hindrances and issues proactively
- indexing strategies
- file growths
- server deployment best practices
- statistics
- wait stats and queues
- and much more
3. Avoid query performance surprises when upgraded to the latest version of SQL Server 2014 and 2016
- new cardinality engine
- column store indexes best practices
- live plans
- azure enhancements
- in-memory OLTP optimizations
- and much more
You will learn:
- About identifying common patterns and anti-patters for database performance tuning
- About resolving optimization hindrances and issues proactively
- How to avoid query performance surprises when upgraded to the latest version of SQL Server 2014/2016