How to Measure IO Latency for Database Files in SQL Server
In order to get information about the amounts of PHYSICAL reads we perform on database files, SQL Server exposes a DMV called...
top of page
Speaking at SQLBits and SQLRally
Next week, I’m going to visit London and Copenhagen for SQLBits and SQLRally Nordic. It’s going to be intense and fun. SQLRally On...
This Can Be the Best Thing in SQL Server 2014
New versions have bombastic and catchy features. But a lot of times, the little, hidden features are the ones that matter the most. I...
Do You Know sys.dm_exec_text_query_plan?
One of the most fundamental DMF’s a SQL Server DBA should know is sys.dm_exec_query_plan. This Dynamic Management Function allows us to...
bottom of page