Question : Currently I use the below two queries to get some properties from the execution plan in stored procedures, […]
Tag: dmv
Index Fragmentation – Am I interpreting the results correctly?
Question : I’m not a DBA, but I’m responsible for a database that currently has hundreds of tables and ~5TB […]
Is there a Windows Performance Counter which contains the “Log Send Rate” for Availability Groups?
Question : I wish to be able to get the “Log Send Rate kb/s”, as per the SSMS AG dashboard […]
Which dmv can help identify the cost of index maintenance for exisitng and missing indexes?
Question : I want to identity: Indexes that are costly to maintain. Missing indexes along with their maintenance cost. By […]
Should I use SQL Server DMVs with NOLOCK
Question : I am trying to monitor live performance data and usage, which cannot be tracked with PerformanceMonitor. What are […]
Is there a way to determine the command timeout for an executing spid
Question : Is there a DMV or other mechanism available that returns the command timeout for an executing session_id? Answer […]
How to script all the service broker elements for each database it is on, in the current server?
Question : I have service broker running on different servers. Just recently I had to rebuild one of the test […]
SQL Server Index recomended but already there (DMVs)
Question : I am using the DMV views to get a list of index recommendations and then I am reviewing […]
Centralized Logs (error, deadlocks, slow queries) For SQL Servers
Question : I want to establish a centralized log for many SQL Servers, similar to the products Graylog or elk […]
Is it possible to get the name of a procedure by it’s plan handle or query plan hash if the execution plan is already cleared from the plan cache?
Question : I ran a home-brew trace for the length of 1 day that captured a few things that were […]