dmv Image

dmv

question
Indupriya avatar image
Indupriya asked Default

How to find which user has accessed which table / which login hit the table /List of tables accessed by all login names

sql-server login tables dmv

0 Likes

0Answers

0 Comments

question
SSGC avatar image
SSGC edited Default

Why dmv query creation_time(cache_time) keep refresh

dmv cache

0 Likes

0Answers

0 Comments

question
Kev Riley avatar image
Kev Riley edited Default

dm_exec_query_stats getting cleared automatically

sql server dba dmv

0 Likes

1Answer

2 Comments

question
kpskumar27 avatar image
kpskumar27 commented Default

confusion in calculating Avg CPU utilization of a Stored procedure

sql server 2012 dmv

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

Highest priority areas to evaluate for extreme disk latency

sql-server-2012 dmv disk-io

This question has an accepted answer. Accepted

11 Likes

3Answers

4 Comments

question
Tim avatar image
Tim edited Default

Performance benchmarking

dmv

This question has an accepted answer. Accepted

3 Likes

1Answer

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

What are the most often used DMVs ?

dmv

0 Likes

2Answers

1 Comment

question
Grant Fritchey avatar image
Grant Fritchey answered Default

Is it normal to restrict DMV access on production server?

dmv permission

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey edited Default

SP and DMV's

dmv interview-questions sp

This question has an accepted answer. Accepted

0 Likes

2Answers

0 Comments

question
sqlLearner 1 avatar image
sqlLearner 1 commented Default

Cycle SQL Statistics

sql-server-2008 tsql dba dmv

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
GPO avatar image
GPO commented Default

DMV to search through synonym DDL

ddl dmv search synonyms

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
skpani avatar image
skpani commented Default

How to track modification counters in SQL 2005/08

sql-server-2008 sql-server-2005 dmv

This question has an accepted answer. Accepted

5 Likes

1Answer

0 Comments

question
flagamba avatar image
flagamba commented Default

how to determine the session associated with a transaction that is blocking the tempdb

tempdb dmv sessions

3 Likes

1Answer

1 Comment

question
askmlx121 avatar image
askmlx121 answered Default

Analysis of login dependencies on sql server

login dmv

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
Fatherjack avatar image
Fatherjack commented Default

DMV - Page Count vs Data size

dmv cache

This question has an accepted answer. Accepted

4 Likes

2Answers

0 Comments

29 Posts
26 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.