SQL Server Performance Troubleshooting



It’s Friday, 05:30pm. You are just receiving an email that informs you that your SQL Server has enormous performance problems! What can you do? How can you identify the problem and resolve it fast? Which tools provides you SQL Server for this task. In this online training you will see you can do effective performance monitoring and troubleshooting with SQL Server. You will learn how to identify performance bottlenecks with tools and information provided by SQL Server and how to resolve the identified performance bottlenecks.

In this 6 hour long online training you will learn about:

  • Performance Monitoring Methology
    • Baselining
    • Performance Monitor
    • Wait Statistics
  • Hardware & OS Configuration
    • CPU & Memory
    • Network
    • Storage
  • Performance Troubleshooting
    • Memory Management
    • Parallelism
    • Locking & Blocking