dmv related issues & queries in DbaXchanger

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

sys.sysprocesses versus DMVs

 sql-server sql-server-2008 sql-server-2005 dmv
Updated January 12, 2018 20:06 PM

Doubts in a Glenn Berry Query ( CPU per Database )

 sql-server-2008-r2 performance dmv
Updated January 12, 2018 20:06 PM

In sys.dm_os_memory_cache_entries view, what does original cost mean?

 sql-server sql-server-2012 dmv
Updated January 12, 2018 01:06 AM

Why am I getting blocked when I call OBJECT_NAME(object_id, database_id) from sys.dm_tran_locks?

 sql-server sql-server-2008-r2 dmv blocking
Updated January 12, 2018 01:06 AM

Invalid object name 'sys.dm_os_volume_stats'

 sql-server sql sql-server-2008-r2 dmv
Updated January 12, 2018 01:06 AM

Error with sys.dm_db_index_physical_stats

 sql-server-2008-r2 dmv compatibility-level
Updated January 12, 2018 01:06 AM

sys.dm_sql_referencing_entities not returning results

 sql-server sql-server-2014 dmv
Updated January 12, 2018 01:06 AM

Grant View Server State - is it possible for a none SA user to have in Azure SQL?

 permissions security azure-sql-database dmv azure-sql-database-v12
Updated October 26, 2017 09:06 AM

Phantom results from a DM or Missing results from Profiler Trace?

 performance profiler dmv
Updated October 09, 2017 18:06 PM

Why aren't some spid values showing up in sys.dm_exec_requests?

 sql-server dmv
Updated October 05, 2017 20:06 PM

Do values in `sys.dm_os_wait_stats` reset to 0 or stop accumulating when they hit the max value?

 sql-server dmv
Updated September 20, 2017 15:06 PM

Interpreting sys.dm_os_sys_memory

 sql-server dmv
Updated August 30, 2017 11:06 AM

Is there any method of looking for Head Blocking history in SQL 2012?

 dmv blocking waits
Updated August 24, 2017 09:06 AM

is there any reason to explicitly grant the server permission CONNECT SQL?

 sql-server permissions dmv automation
Updated July 27, 2017 12:06 PM

how to find out the `proper` case for each word in sql server?

 sql-server best-practices dmv
Updated July 27, 2017 11:06 AM

what is difference between last_worker_time and last_elapsed_time in DMV sys.dm_exec_query_stats?

 sql-server sql-server-2005 dmv
Updated July 26, 2017 22:06 PM

In SQL Server, is there a way to determine the values of the parameters passed to an executing stored procedure

 sql sql-server-2005 dmv
Updated July 26, 2017 11:06 AM

Finding login or user name of last person to use a DB

 sql-server sql-server-2008-r2 dmv
Updated July 07, 2017 19:06 PM

SQL Server Average Lock Wait time Historical data

 sql-server-2012 performance dmv
Updated June 19, 2017 11:06 AM

Confusion about connection_id in SQL Server DMV

 sql-server dmv
Updated June 17, 2017 14:06 PM

PAGEIOLATCH wait type

 sql-server dmv wait-types
Updated May 17, 2017 12:06 PM

How to include "Actual Row" counts in Execution plans pulled from the Query Cache or Query Store?

 sql-server execution-plan dmv
Updated May 10, 2017 15:06 PM

Pulling Top queries returns NULL in query plan and sql text

 sql-server sql dmv top
Updated May 09, 2017 08:06 AM

Is there DMV for seeing view access count?

 sql-server view dmv
Updated May 08, 2017 14:06 PM

Nonclustered indexes

 sql sql-server-2012 t-sql dmv
Updated April 28, 2017 11:06 AM
Showing Page 1 of 0

Query Search

Categories