Geek Sync Webcast : Boost SQL Server Settings in the Cloud and On Premises
DBAs and Developers often work across multiple versions of SQL Server, both on premises and deployed on VMs which may be in the cloud. It is difficult to know every single configuration setting introduced in each version of SQL Server. To keep the behavior of SQL Server predictable, many of the newer settings are kept off or disabled. In this fast-paced demo-oriented session Pinal Dave will show three critical and several other important configuration settings, which once enabled instantly improve the performance of SQL Server. We will further explore these settings to understand how they work in the cloud and have a comprehensive understanding of the SQL Server’s performance. By the end, you will understand how to enable a few important settings for SQL Server which can improve SQL Server performance by multifold.
See Also:
- Whitepaper: Five Reasons Why SQL Server Health Checks are Life Savers
- Whitepaper: 7 Most Important MySQL Performance Tuning Checks
- Whitepaper: A User-centric, Collaborative, Holistic Philosophy of Tuning the Application Stack
- Whitepaper: Beginning Performance Tuning
- Webcast: New Features in SQL Server That Will Change the Way You Tune
- Webcast: Performance Tune Like an MVP
- Webcast: Practical Performance Tuning with SQL Wait Stats
- Webcast: SQL Server 2017 – Let’s Learn Automatic Tuning
- Webcast: SQL Server Performance Tuning – Analyzing Past to Predict Future
- Webcast: The Five Essential Scripts for Performance Tuning
- Webcast: Performance in 60 Seconds – SQL Tricks Everybody MUST Know
- Webcast: Performance Tuning Your SQL Server Database and Maybe Even Your Data
- Webcast: SQL Server Performance Tuning – Advanced Techniques
- Webcast: SQL Server Performance Tuning Tips and Tricks
- Webcast: Identifying and Solving Common SQL Server Performance Problems
- Webcast: SQL Server Setup and Configuration Best Practices (Including SQL 2017 and Linux)
Topics :
Products :
Pinal Dave is a technology enthusiast and independent consultant with over thirteen years of experience in the information technology sector. He has successfully authored 11 SQL Server database books, 18 Pluralsight courses and written over 3200 articles on database technology via his blog http://blog.sqlauthority.com. Rounding out his professional career, Pinal has held key positions as Sr. Consultant for SolidQ and as a Technology Evangelist for Pluralist and Microsoft. Pinal holds a Master of Science from the University of Southern California, and numerous professional certifications, including MCTS, MCDBA and MCAD (.NET).
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.