Geek Sync Webcast : Geek Sync – SQL Server Secrets DBAs Always Wanted to Know
Database Administrators and Developers often work across multiple versions of SQL Server. It is not possible to know every single configuration setting introduced in the latest version of SQL Server. To keep predictable SQL Server behavior, many of the newly introduced settings are kept off or disabled. In this fast-paced, demo-oriented session we will discuss the most important configuration settings that instantly give a performance boost to SQL Server once enabled.
Speaker: Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 33 Pluralsight courses and has written over 5100 articles on database technology on his blog at https://blog.sqlauthority.com. Along with 17+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.
Topics :
Products :
Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 33 Pluralsight courses and has written over 5100 articles on database technology on his blog at https://blog.sqlauthority.com. Along with 17+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.
24X7 SQL performance monitoring, alerting and diagnostics
- Monitor performance for physical, virtual, and cloud environments.
- Monitor queries and query plans to see the causes of blocks and deadlocks.
- Monitor application transactions with SQL Workload Analysis add-on.
- View expert recommendations from SQL Doctor to optimize performance.
- Alert predictively with settings to avoid false alerts.
- View summary of top issues and alerts with the web console add-on.