Performance Troubleshooting with Windows Resource Monitor - Part 2

In the second part of the Resource Monitor series we conclude with a look using the Memory tab and Disk tab to diagnose performance issues.

Performance Troubleshooting with Windows Resource Monitor

Windows Resource Monitor can be a very useful tool for initial diagnosis of performance issues. In this two part series we look at how to troubleshoot performance issues using Resource Monitor.

An nHibernate Head Scratcher

An interesting mystery on why some nHibernate performance issues might exist on your systems. Read this piece from SQL Server expert David Poole and look to see if this is a problem you can easily solve in your environment.

SQL Server Index Maintenance Performance Tuning for Large Tables

This article describes a real-world example of performance tuning index maintenance for a large table of approximately 1 billion rows.

How to Identify CPU Bottlenecks in SQL Server

We experience regular slowdowns on our MS SQL database. After analyzing the memory usage we would like to continue the root cause investigation by examining CPU bottlenecks. What is your recommendation to recognize CPU related bottlenecks in SQL Server?

Slow in the Application, Fast in SSMS? Understanding Performance Mysteries

When I read various forums about SQL Server, I frequently see questions from deeply mystified posters. They have identified a slow query or stored procedure in their application. They cull the SQL batch from the application and run it in SQL Server Management Studio (SSMS) to analyse it, only to find that the response is instantaneous. At this point they are inclined to think that SQL Server is all about magic. A similar mystery is when a developer has extracted a query in his stored procedure to run it stand-alone only to find that it runs much faster – or much slower – than inside the procedure.

Disk Partitions

Which of Your Stored Procedures are Using the Most Resources?

Dynamic Management Views and Functions aren't always easy to understand. However, they are the easiest way of finding out which of your stored procedures are using up the most resources. Greg takes the time to explain how and why these DMVs and DMFs get their information. Suddenly, it all gets clearer.

Trending Buffer Pool Performance Using DMV sys.dm_os_performance_counters

I'd seen you posted a tip on capturing SQL based PerfMon counters using sys.dm_os_performance_counters. What queries can I run against those stored results that would allow me to examine memory usage on my SQL instance?

Wait statistics, or please tell me where it hurts

How many times have you walked up to a SQL Server that has a performance problem and wondered where to start looking?