Webcast : What You Need to Know About Managing Your SQL Server Performance

When it comes to SQL Server performance, best practices may not always be best. Each SQL Server instance is different. To ensure that your SQL Server is performing optimally, you first need to know what the norm is before you can measure and pinpoint where the performance bottlenecks are. The challenges in analyzing SQL Server performance are twofold: There are overwhelming amounts of metadata, statistics, and performance counters available. At the same time, deciding where one should start the analysis can be quite confusing.

In this session, IT Pro expert Robert Pearl will dive into creating a SQL Server performance roadmap by showing how to create a performance baseline, using the time-tested performance methodology known as waits and queues. He will discuss some of SQL Server’s native DMVs to capture real-time performance data, aggregate it for historical analysis, and report on useful data to highlight performance issues. This session will be helpful for experienced as well as non-expert DBAs who do not have the time to ramp up on the art of performance tuning.

Topics :

Products :

Robert Pearl & Bullett Manale

IDERA’s VP of Sales Engingeering, has been working in technology for over 25 years. Starting as a tech support technician for Iomega supporting their backup software, he has since been a technical trainer and consultant for Deloitte, a sales engineer at Centerbeam, and a project manager at Shell Oil Company.

Try SQL Diagnostic Manager for SQL Server FREE for 14 days

SQL Diagnostic Manager Repository dashboard

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.

Start for Free