Webcast : Identifying and Solving Common SQL Server Performance Problems
About this webcast:
Performance is always one of the DBA’s top priorities. The one thing that you know for certain is that if SQL Server isn’t performing up to the user’s expectations, you’ll hear about it. SQL Server is a complex system and there are a lot of factors that go into making it perform well and keeping it performing well. In this webcast, join Michael Otey, senior contributing editor at SQLServerPro, as he dives into some of the performance problems that a lot of SQL Server instances run into as well as the recommended industry best practices from Microsoft, MVPs and other database experts on how to handle them. Some of the main areas that he will cover include:
- Keeping the wrong default configuration values
- Monitoring SQL Server instances in Azure and AWS
- Handling Tempdb contention
- Indexing mistakes
- Identifying problem queries
- Dealing with CPXPACKET waits
- Detecting SQL Server memory pressure
Subsequently, Tep Chantra from IDERA will discuss IDERA’s powerful solution for performance tuning with expert commentations for SQL Server in the hybrid cloud. SQL Doctor retrieves all of the necessary information, analyzes the results, pinpoints potential problems, and determines the resolution in minutes rather than hours. SQL Doctor leverages proven industry best practices to analyze the performance and provide expert recommendations plus executable scripts. It targets SQL Server (on premise and cloud virtual machines), Azure SQL Database, and Amazon RDS. SQL Doctor makes daily tasks easier for novices and experts at performance tuning.
Here is your download link for SQL Doctor!
Please choose the file that meets your system requirements:
You’ll also receive a confirmation email with a download link for your product. To ensure email delivery, please whitelist [email protected]. If you do not receive your email, please be sure to check both your inbox and filters for a message from [email protected].
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: Boost SQL Server Settings in the Cloud and On Premises
- 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: SQL Server Setup and Configuration Best Practices (Including SQL 2017 and Linux)
Topics :
Products :
Tep Chantra has worked in the IT industry for 10+ years taking on various roles such as Customer Support. His current role is the Product Manager for the SQL Doctor product at IDERA.
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.