Session Details

21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs

Pinal Dave
Full Day
Database Administration and Development
Architect, DBA
“Accidental DBAs” are the real superheroes for any organizations. When no one in the organization volunteers to solve the pressing problems, accidental DBAs often jump-in to save the day. Accidental DBAs quickly learn all the routine administrative tasks as clear instructions are often available at various educational portals, product support website and on the internet. The real big challenge accidental DBAs often face when they have to identify and resolve application performance problems of the system under a heavy workload. This quick-paced demo-oriented session will cover the real-world pain points for accidental DBAs who have keen interesting in catching performance troublemakers. Here are the major topics which we will cover in this session: • Optimal server configuration for performance • Efficient database settings for balanced resource consumption • Understanding self-healing index tuning mechanism • Maintenance strategy and guidance • Faster backup and restore strategy • DBCC best practices • Troubleshooting slow running query with Wait Statistics • SQL Server 2017 New Features (Auto-Tuning, Query Store, Adaptive Joins, etc.) In the last hour, we will play an interactive fun game with WHERE clause and Multi-Column index, where the individual who gets the maximum wrong answer will be a winner! In this session, we will explore 21 essential scripts which every DBA should keep handy, so they can stay alert fight and win the real-world problems. At the end of the pre-con, DBAs will learn how they can convert the accidents into opportunities.