Toggle navigation
Categories
ServerfaultXchanger
SuperuserXchanger
UbuntuXchanger
WebappsXchanger
WebmastersXchanger
ProgrammersXchanger
DbaXchanger
DrupalXchanger
WordpressXchanger
MagentoXchanger
JoomlaXchanger
AndroidXchanger
AppleXchanger
GameXchanger
GamingXchanger
BlenderXchanger
UxXchanger
CookingXchanger
PhotoXchanger
StatsXchanger
MathXchanger
DiyXchanger
GisXchanger
TexXchanger
MetaXchanger
ElectronicsXchanger
StackoverflowXchanger
BitcoinXchanger
EthereumXcanger
dmv related issues & queries in DbaXchanger
Poor Performance Running dm_exec_query_stats
sql-server
sql
query-performance
dmv
Updated April 03, 2018 19:06 PM
0
answers
2
views
0
votes
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
0
answers
6
views
0
votes
sys.dm_exec_requests and cpu_time
dmv
Updated February 15, 2018 02:06 AM
1
answers
185
views
0
votes
SQL Memory Usage Cumulative for each Database
sql-server
performance-tuning
dmv
Updated January 24, 2018 07:06 AM
0
answers
3
views
0
votes
SQL Server DMV to show if database is used
sql-server
dmv
Updated January 23, 2018 17:06 PM
1
answers
814
views
3
votes
SQL CPU Current% By Database
sql-server
performance-tuning
dmv
Updated January 23, 2018 14:06 PM
0
answers
5
views
0
votes
SQL CPU % Current Use By Database
sql-server
performance-tuning
dmv
Updated January 23, 2018 08:06 AM
0
answers
7
views
0
votes
SQL CPU % Use By Database
sql-server
performance-tuning
dmv
Updated January 23, 2018 07:06 AM
0
answers
7
views
0
votes
How do I tell which Edition and Version my SSAS Instance is running?
ssas
dmv
tabular-model
Updated January 23, 2018 06:06 AM
2
answers
1048
views
1
votes
SQL DMVs with NOLOCK
sql-server
performance-tuning
dmv
Updated January 22, 2018 05:06 AM
0
answers
2
views
1
votes
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
0
answers
2
views
0
votes
sys.sysprocesses versus DMVs
sql-server
sql-server-2008
sql-server-2005
dmv
Updated January 12, 2018 20:06 PM
1
answers
1132
views
4
votes
Doubts in a Glenn Berry Query ( CPU per Database )
sql-server-2008-r2
performance
dmv
Updated January 12, 2018 20:06 PM
2
answers
335
views
6
votes
Invalid object name 'sys.dm_os_volume_stats'
sql-server
sql
sql-server-2008-r2
dmv
Updated January 12, 2018 01:06 AM
1
answers
3554
views
0
votes
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
1
answers
543
views
4
votes
sys.dm_sql_referencing_entities not returning results
sql-server
sql-server-2014
dmv
Updated January 12, 2018 01:06 AM
2
answers
332
views
1
votes
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
1
answers
173
views
0
votes
Error with sys.dm_db_index_physical_stats
sql-server-2008-r2
dmv
compatibility-level
Updated January 12, 2018 01:06 AM
2
answers
255
views
2
votes
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
0
answers
3
views
0
votes
Phantom results from a DM or Missing results from Profiler Trace?
performance
profiler
dmv
Updated October 09, 2017 18:06 PM
0
answers
5
views
0
votes
Why aren't some spid values showing up in sys.dm_exec_requests?
sql-server
dmv
Updated October 05, 2017 20:06 PM
2
answers
15
views
1
votes
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
0
answers
15
views
3
votes
Interpreting sys.dm_os_sys_memory
sql-server
dmv
Updated August 30, 2017 11:06 AM
1
answers
544
views
4
votes
Is there any method of looking for Head Blocking history in SQL 2012?
dmv
blocking
waits
Updated August 24, 2017 09:06 AM
0
answers
4
views
0
votes
is there any reason to explicitly grant the server permission CONNECT SQL?
sql-server
permissions
dmv
automation
Updated July 27, 2017 12:06 PM
1
answers
7
views
0
votes
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
0
answers
8
views
0
votes
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
2
answers
4839
views
8
votes
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
3
answers
2444
views
5
votes
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
1
answers
5780
views
0
votes
SQL Server Average Lock Wait time Historical data
sql-server-2012
performance
dmv
Updated June 19, 2017 11:06 AM
1
answers
4
views
0
votes
Confusion about connection_id in SQL Server DMV
sql-server
dmv
Updated June 17, 2017 14:06 PM
0
answers
3
views
0
votes
PAGEIOLATCH wait type
sql-server
dmv
wait-types
Updated May 17, 2017 12:06 PM
2
answers
174
views
4
votes
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
1
answers
8
views
1
votes
Pulling Top queries returns NULL in query plan and sql text
sql-server
sql
dmv
top
Updated May 09, 2017 08:06 AM
3
answers
1979
views
4
votes
Is there DMV for seeing view access count?
sql-server
view
dmv
Updated May 08, 2017 14:06 PM
1
answers
9
views
1
votes
Nonclustered indexes
sql
sql-server-2012
t-sql
dmv
Updated April 28, 2017 11:06 AM
0
answers
72
views
1
votes
sys.dm_exec_sql_text returns NULL in dbid, objectid, and number columns, but not text
sql-server
dmv
Updated April 19, 2017 22:06 PM
0
answers
11
views
0
votes
T-SQL - Is there a way to show index_advantage more friendly?
sql-server
t-sql
dmv
Updated April 06, 2017 22:06 PM
0
answers
9
views
0
votes
Improve performance of sys.dm_db_index_physical_stats
sql-server
query-performance
dmv
Updated March 06, 2017 22:06 PM
4
answers
16719
views
12
votes
stats_column_id and index_column_id do not update with physical order of clustered index is changed
sql-server
statistics
dmv
Updated January 11, 2017 09:02 AM
1
answers
323
views
12
votes
Is there a DMV that shows the aggregate logical reads on a SQL server?
sql-server
sql
dmv
Updated September 07, 2016 09:02 AM
1
answers
30
views
1
votes
Using DMVs with Database Tuning Advisor
performance
dmv
Updated July 13, 2016 08:02 AM
0
answers
5
views
0
votes
Query to find plan details for a specific stored procedure, searching by name
sql-server
sql-server-2008-r2
stored-procedures
dmv
Updated July 06, 2016 08:02 AM
0
answers
7
views
1
votes
Plan cache size and reserved memory
sql-server
memory
dmv
database-internals
plan-cache
Updated June 11, 2016 08:02 AM
0
answers
236
views
6
votes
Wrong Last Execution Time sys.dm_exec_procedure_stats
sql
sql-server-2008-r2
stored-procedures
dmv
Updated June 10, 2016 08:02 AM
1
answers
20
views
0
votes
Running query against DMVs for Query Stats and Execution Plans joined to sys.databases
sql-server
query-performance
execution-plan
dmv
Updated May 19, 2016 07:46 AM
2
answers
112
views
5
votes
reporting space consumption to files in filegroup - how to reverse-engineer the algorithm spreading data across files
sql-server
performance-tuning
monitoring
disk-space
dmv
Updated May 11, 2016 08:02 AM
2
answers
139
views
5
votes
sys.dm_exec_procedure_stats reset
sql-server
dmv
Updated April 27, 2016 08:02 AM
1
answers
8
views
0
votes
sys.dm_exec_procedure_stats missing history?
sql-server
sql-server-2008-r2
stored-procedures
dmv
Updated April 27, 2016 08:02 AM
1
answers
101
views
2
votes
Does dm_exec_procedure_stats.total_worker_time include signal waits?
sql-server
dmv
waits
Updated April 11, 2016 09:02 AM
0
answers
8
views
0
votes
Showing Page 1 of 0
Query Search
Categories
ServerfaultXchanger
SuperuserXchanger
UbuntuXchanger
WebappsXchanger
WebmastersXchanger
ProgrammersXchanger
DbaXchanger
DrupalXchanger
WordpressXchanger
MagentoXchanger
JoomlaXchanger
AndroidXchanger
AppleXchanger
GameXchanger
GamingXchanger
BlenderXchanger
UxXchanger
CookingXchanger
PhotoXchanger
StatsXchanger
MathXchanger
DiyXchanger
GisXchanger
TexXchanger
MetaXchanger
ElectronicsXchanger
StackoverflowXchanger
BitcoinXchanger
EthereumXcanger