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
Madeira Team
- Feb 24, 2015
- 1 min
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...
Madeira Team
- Sep 3, 2014
- 1 min
Query Stats script
This query stats script returns aggregated statistics information for every query statement in the cached plan. Use it to get details on...
Madeira Team
- Mar 5, 2014
- 2 min
A Community Challenge
Earlier this week, I delivered a presentation called “Query Progress Tracking in SQL Server” to my local user group. Among other...
Madeira Team
- Jun 26, 2013
- 1 min
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...
Madeira Team
- Mar 12, 2013
- 2 min
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