Monthly Archives: August 2018

Dynamic management views

In order to identify the  server resources used by your queries, here are the two DMV's.
sys.dm_Exec_requests  Dmv can be used to display the requests currently executing on sql server.
select cpu_time, reads,total_elapsed_time,logical_reads, row_count from Sys.dm_exec_requests
cpu_time : cpu time in milliseconds used by this request or by the requests in this sesssion.
reads : number of reads performed by this request or by the requests in this session.
logical_reads : Nuber of logical reads that have been perfomed by the requests or by the requests in this session.
row_count : Number of rows that have been returned to the client by this request.

 

select cpu_time,reads, total_elapsed_time, logical_reads,row_count from sys.dm_exec_sessions
these Queries are supposed to run after DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS