Windows Performance Monitoring: Part 2

This is the continuation of the live presentation I did a couple weeks ago. 

 This one covers disk counters, memory architecture, and counters.

Find the video here.

Find LogSpace Used

 

Find out how to query the log space usage for all DBs on the server with a single statement. 

This is a quick way to get the % of log space used and even program against the results.

Find video here.

Interpreting Disk Queues

Disk queues are a mystery for the majority of DBAs.  They may know that they need to look at them, but they have no idea what they mean.  Here I’ll show you how to know what you’re looking at to see when your disk queues are too high.  This tutorial doesn’t go into how to fix the problem really, it’s more just how to diagnose it. 

Here's the link.

Real news, real tech.