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

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ...

Redgate, the Database DevOps solutions provider, is launching upgrades to its SQL Server performance monitoring tool, strengthening its query tuning and optimization functions to facilitate enhanced ...

What happens on the typical load-testing project? For me, the projects tend to fall into one of two buckets. Bucket No. 1: We've got a problem. Bucket No. 2: We've got a performance penalty clause in ...

Comparing cursor vs. WHILE loop performance in SQL Server 2008 Your email has been sent Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option ...

Since SQL Server on Linux is still pre-GA, Quest is supporting an earlier build and, as it goes GA, Quest will do the same, said Davoll. “We are on the early bandwagon and want to make sure that, as ...