dmv related issues & queries in DbaXchanger

Plan Propertioes in SQL Server 2008

sql-server-2008 query-performance performance-tuning dmv
Updated May 15, 2019 16:06 PM

sys.dm_db_index_usage_stats showing incorrect figures for last_user_update

index sql-server-2014 dmv
Updated May 09, 2019 21:06 PM

How to find if a column is referenced in a computed column?

t-sql sql-server-2016 dmv system-tables
Updated April 25, 2019 12:06 PM

sys.dm_db_stats_properties seems to be misbehaving for a small table - how to get the number of records of a table in a different way?

sql-server sql-server-2016 statistics scripting dmv
Updated April 23, 2019 22:06 PM

Frequently Querying the DMV - sys.dm_exec_sessions, sys.dm_exec_connections and sys.dm_exec_requests

dmv
Updated March 13, 2019 02:06 AM

How to find out the oldest full backup still existing on disk?

sql-server backup restore dmv files
Updated February 25, 2019 19:06 PM

Index Fragmentation - Am I interpreting the results correctly?

sql-server index dmv
Updated February 19, 2019 06:06 AM

When is dm_exec_procedure_stats updated?

sql-server sql-server-2012 statistics dmv
Updated February 08, 2019 20:06 PM

Optimizing a DMV query

sql-server execution-plan dmv
Updated February 02, 2019 13:06 PM

Is there a Windows Performance Counter which contains the "Log Send Rate" for Availability Groups?

sql-server performance availability-groups dmv
Updated February 01, 2019 09:06 AM

Centralized Logs (error, deadlocks, slow queries) For SQL Servers

sql-server logs dmv extended-events logging
Updated January 30, 2019 17:06 PM

What's the differences between sys.dm_exec_query_stats and sys.dm_exec_cached_plans?

sql-server execution-plan dmv metadata
Updated January 12, 2019 09:06 AM

DMV Index proposals still reported as missing

sql-server index index-tuning dmv
Updated January 01, 2019 21:06 PM

Some columns sys.dm_io_virtual_file_stats interpretition

dmv
Updated December 18, 2018 13:06 PM

How to find out the service accounts for each of my instances in the current server?

sql-server sql-server-2016 dmv instance service-accounts
Updated November 28, 2018 14:06 PM

Print Column Names for Synonym for Table in Another Database

sql-server sql-server-2016 view dmv
Updated November 27, 2018 10:06 AM

Print Column Names for Table in Another Database

sql-server sql-server-2016 dmv
Updated November 27, 2018 07:06 AM

How to recreate a Table from a View?

sql-server t-sql sql-server-2016 view dmv
Updated November 27, 2018 05:06 AM

service broker - poison message - how to handle? how to enable poison messase handling?

sql-server sql-server-2016 dmv service-broker troubleshooting
Updated November 23, 2018 12:06 PM

is there a way to find out what route and endpoint my service broker session is using?

sql-server sql-server-2016 connectivity dmv service-broker
Updated November 17, 2018 17:06 PM

is there any advantage when troubleshooting service broker, to create the queue with retention=ON?

sql-server sql-server-2016 dmv service-broker
Updated November 14, 2018 15:06 PM

How to script all the service broker elements for each database it is on, in the current server?

sql-server sql-server-2016 scripting dmv service-broker
Updated November 12, 2018 18:06 PM

availability groups - checking for primary server - cannot call a procedure with parameters

sql-server-2016 stored-procedures availability-groups jobs dmv
Updated November 09, 2018 16:06 PM

Monitor volume of data returned to the client application

sql-server-2014 monitoring dmv waits
Updated November 08, 2018 19:06 PM

how to optimise this group by on sys.dm_exec_query_stats?

sql-server query-performance optimization group-by dmv
Updated October 25, 2018 16:06 PM

leaf_allocation_count in dm_db_index_operational_stats is always one but number of pages increases

index sql-server-2016 database-internals dmv
Updated October 09, 2018 15:06 PM

The current security context cannot be reverted

sql-server sql-server-2016 permissions logins dmv
Updated October 09, 2018 13:06 PM

run script on sys.dm_exec_query_stats in the Query list result update top 200 and @Param1

sql-server sql-server-2012 dmv
Updated October 04, 2018 09:06 AM

What connection do internal sessions belong to in MS SQL Server?

sql-server connections dmv session
Updated October 01, 2018 09:06 AM

Is there a quick way to find all columns in SQL Server 2008 R2 that are encrypted/have encrypted data?

sql-server sql-server-2008-r2 encryption information-schema dmv
Updated September 14, 2018 20:06 PM

Query to get Object_ID and Dimension_Name from DMV

sql-server ssas dmv
Updated August 30, 2018 07:06 AM

Find out recovery model changes

sql sql-server-2014 backup dmv recovery-model
Updated August 14, 2018 14:06 PM

replace all references to a drive inside the jobs to another drive

sql-server sql-server-2016 jobs dmv metadata
Updated August 10, 2018 11:06 AM

How to get the definition of a database trigger?

sql-server sql-server-2016 trigger dmv metadata
Updated August 09, 2018 15:06 PM

Group together similar queries in sys.dm_exec_sql_text

sql-server sql-server-2008 dmv plan-cache
Updated August 07, 2018 14:06 PM

Analysis of historical queries which ran on the database

sql-server sql-server-2012 query-performance ssms dmv
Updated August 06, 2018 10:06 AM

Zero Rows return on querying DMV sys.dm_os_performance_counters

sql-server sql-server-2014 dmv
Updated June 30, 2018 21:06 PM

List primary replicas and non-HA databases - excluding forwarder replicas

sql-server availability-groups dmv distributed-availability-groups
Updated June 21, 2018 13:06 PM

Batch Requests/sec reported by DMV millions of times larger than Activity Monitor

sql-server performance dmv
Updated May 15, 2018 15:06 PM

Poor Performance Running dm_exec_query_stats

sql-server sql query-performance dmv
Updated April 03, 2018 19:06 PM

how to find the database context of the last sql statement?

sql-server sql-server-2016 dynamic-sql dmv
Updated March 28, 2018 11:06 AM

sys.dm_exec_requests and cpu_time

dmv
Updated February 15, 2018 02:06 AM

SQL Memory Usage Cumulative for each Database

sql-server performance-tuning dmv
Updated January 24, 2018 07:06 AM

SQL Server DMV to show if database is used

sql-server dmv
Updated January 23, 2018 17:06 PM

SQL CPU Current% By Database

sql-server performance-tuning dmv
Updated January 23, 2018 14:06 PM

SQL CPU % Current Use By Database

sql-server performance-tuning dmv
Updated January 23, 2018 08:06 AM

SQL CPU % Use By Database

sql-server performance-tuning dmv
Updated January 23, 2018 07:06 AM

How do I tell which Edition and Version my SSAS Instance is running?

ssas dmv tabular-model
Updated January 23, 2018 06:06 AM

SQL DMVs with NOLOCK

sql-server performance-tuning dmv
Updated January 22, 2018 05:06 AM

Why is sys.dm_exec_connection.connect_time later than sys.dm_exec_sessions.login_time for user processes for some cases?

sql-server dmv
Updated January 19, 2018 02:06 AM

Showing Page 1 of 0