SQL Server 2008/R2 - Performance Monitoring & Troubleshooting (In-depth) - Partner Services and Support Team Blog - Site Home

SQL Server 2008/R2 - Performance Monitoring & Troubleshooting (In-depth)

Wriju Ghosh

9 Aug 2011 5:15 PM

Comments 0

- SQL Performance Monitoring using

      - Windows Internal Tools

      - SQL Internal Tools

      - Out of Box Tools

- Monitoring & Troubleshooting Bottlenecks

      - CPU Bottleneck

              - Query Processing

              - Query Tuning Steps

      - Memory Bottleneck

              - Windows Memory Issues

              - SQL memory Issues

              - TempDB Issues

      - I/O Bottleneck

              - Indexes

              - Joins

SQL Server, SQL Server 2008, SQL Server 2008 R2