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

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Database performance is rarely a single "fix it and forget it" task. SQL Server workloads shift over time. A sluggish ...

We run JD Edwards' One World here on an NT 4 sql server. It's a pretty decent server but lately it's been running like a dog. It's a 4-way 450mhz Xeon(2mb cache) machine with 4gigs of ram. All drives ...

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

Latest service pack comes more than a year after the last service pack, and also adds a number of enhanced monitoring capabilities. It's been a long time coming -- nearly a year and a half since ...

SolarWinds has expanded its database performance management portfolio with the launch of SolarWinds Database Insights for SQL Server. Uniting the features and functionality of the SolarWinds Database ...

Expert Tips for Using SQL Server’s Extended Events and Notifications SQL Server offers plenty of details on problems that have already occurred. But what about potential issues lurking in the shadows?

With the latest public preview available, it’s time to decide if you want to upgrade to Microsoft’s most cloud-connected version of SQL Server so far. Three decades on, SQL Server is still a database ...