SQL Server has a bounty of self-diagnostic data that any good DBA can monitor and analyze. This analysis is often triggered by an unexpected event like queries that begin to run longer than usual or a spike in CPU utilization. Finding the root cause of such events is not always easy but through a simple […]
Tag Archives: performance
Technical communities are thriving and the knowledge they provide to professionals is immense. In the SQL Server community especially, countless blog sites, forum posts, tweets, webinars and white papers exist that help DBAs solve tough problems every day and we are all fortunate to have such information available to us with a simple Web search. Sometimes, […]
We are very excited to announce that SQLWatchmen is now a Redgate Certified Partner. For those unfamiliar with Redgate, they are a leading provider of software for professionals working on the Microsoft data platform. Our favorite product from Redgate is their SQL Toolbelt. This suite of tools helps users implement DevOps best practice for their databases, […]
You know the old joke that goes, “A DBA walks into a bar, sees some friends at a couple of tables and asks if he can join them.”? Well, as DBAs we are used to dealing with tables. Whether the data comes from a log file, trace file, or XML, we want to turn it […]