Most Popular None

How many “MPP” is your team getting?

  Have you heard about the new metric by which to measure how hard your IT support technicians are working?  It’s “MPP” or “Miles Per Pair”. IT support technicians can put several miles on a pair of shoes in a day as they move from one user to another to address and resolve issues. Face […]

Read More

A Layman’s Guide to Climbing the SQL Server Index B-tree (Part 3)

Read Part 1 Read Part 2 This was originally intended to be a two-part blog, but I keep finding other areas to explore. Shortly after completing Part 2, I realized that perhaps I should traverse a row compressed index to see how the SQL Server® structures it. Then, the other night, I gave a presentation to our […]

Read More

Merits of a SQL Server Performance Analyzer vs. Performance Monitor(s)

Abstract SolarWinds® Database Performance Analyzer (DPA) is a performance analysis product unlike other resource-focused health and alerting monitors; it allows a comprehensive determination of why a particular TSQL statement or stored procedure is slow or creating a performance issue. DPA achieves its performance analysis using wait-based analytics vs. resource utilization/consumption approach. By using this technology, […]

Read More