I'm seeing a large amount of pagefile useage on my server running 2 SQL server 2005 x64 instances. Server has 24gb of memory, each instance has 8gb allocated to it. Rest of the memory goes to other ...

Hi everyone! It's great to be back on Database Trends and Applications magazine. While I dropped out of the regular columnist position for quite a while, I was still hard at it promoting strong ...

So I have the dreaded C-level user statement/support request to deal with "Everything is slow". No numbers, qualifiers, time, quantitiave measurements of any kind. So working my way in from the ...

The PerfMon tool has a lot troubleshooting advantages going for it, but its interface isn't necessarily one of them. Here's an alternative. Performance counters have been around forever in Windows.