As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...

SQL Server performance is slow. Users are complaining. Your boss wants to know what's going on and what you can do to improve SQL Server performance. Where do you start? Which SQL Server query should ...

As I discussed in an earlier column, SQL Server keeps a plan cached for each query it sees (assuming the query requires planning in the first place, of course). That's great for speeding up processing ...