While working with SQL Server databases, if you often find the database performance sluggish, it could be due to bad coding of procedures or incorrectly set database variables. Here's a tool that can ...

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 ...

I have users complaining about slow performance in one of our internal applications. The application is, essentially, a front end to a SQL database. We've built a new server for it because the old one ...