** Please note Pre-Conference sessions are available for an additional registration fee of $495 **
This demo-oriented, full-day pre-conference session answers the questions that database administrators (DBAs) and developers often have about performance tuning and query optimization. Some problems have straightforward answers, but others are often invisible or need attention without even a problem statement. This session is divided into these three major components:
- Identify common patterns and antipatterns for database performance tuning; for example, slow-running queries, I/O-intensive operations, CPU bottlenecks, memory optimizations, tempdb contention, and more
- Resolve optimization hindrances and issues proactively; for example, indexing strategies, file growths, server deployment best practices, statistics, wait stats and queues, and more
- Avoid query performance surprises when upgraded to the most recent version of SQL Server 2014; for example, new cardinality engine, ColumnStore indexes best practices, live plans, Azure enhancements, in-memory online transaction processing (OLTP) optimizations, and more
We discuss 42 tips, tricks, and scripts in this session. Every attendee will have those scripts handy upon completion of the session.
No material found.