The most recent content from our members.
When it comes to frequent performance bottlenecks on SQL Server, few are as frequent or as problematic is I/O latency. Relational databases, by their very nature, perform a great deal of I/O both to support the ACID properties of transactions as well as to cache the most frequently used data and code for maximum…
We've recently come across multiple customers who have had excessively high LCK_M_SCH_M waits. These surface in sys.dm_os_wait_stats, but much more visibly in the SQL Sentry Performance Advisor dashboard: Upon digging deeper, we observed the following resource_description in sys.dm_os_waiting_tasks: metadatalock…
It looks like you're new here. Sign in or register to get started.