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

Ok, so my current company has no real monitoring, at all (yes, I know). It hurts. We are, thankfully getting SCOM 2012 soon, so general OS monitoring will be taken care of for perfmon type counters ...

The expanded support provides visibility into query-level metrics and detailed explain plans so all Microsoft customers can benefit from Database Monitoring With this expanded support, engineers and ...

Microsoft SQL Server MVP Denny Cherry breaks down multiple ways on how to troubleshoot a type -2 blocking session ID error. When we look at sessions being blocked in ...

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

For developers working with SQL Server, few performance tuning techniques are as essential--or as frequently misunderstood--as indexing. Done right, indexing can drastically improve application ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...