This particular issue I’m about to describe should be pretty rare, but I’m posting this here in the event that someone else encounters it and then finds this post and then hopefully applies the “minimum required dose” required to fix the problem instead of using more sweeping methods such as restoring from database backup… I […]
Joe Sack
SQL Server Performance Tuning, High Availability and Disaster Recovery Blog
One resolution to “sys.sql_dependencies does not have a matching row”
Posted on: November 21, 2011 11:59 am
Exceptions – what sys.dm_db_index_usage_stats doesn’t tell you
Posted on: November 11, 2011 1:20 am
I was thinking back to a conversation I had some time ago regarding cases when sys.dm_db_index_usage_stats does not get updated after an index is used for just the statistics associated with the indexed columns. What makes this profession so interesting is that almost every tool we use has a "yes, but…" associated with it. What […]
Observer overhead – the perils of too much tracing
Posted on: November 1, 2011 7:56 am
While it’s good to keep an eye on your SQL Server instances – it’s a balancing act. On one side you want to be sure that you are monitoring critical areas and pulling enough information to perform root cause analysis on anything out-of-the-norm. But on the other side, if you pull an excessive amount of […]
