Peformance data - SQL DMV

1. I/O Statistics in individual database

select num_of_reads, num_of_bytes_read,

num_of_writes, num_of_bytes_written

from sys.dm_io_virtual_file_stats(db_id('tempdb'), 1)

This is the output:

num_of_reads = 5643 num_of_bytes_read =361488384 num_of_writes 5434 num_of_bytes_written =353394688

 

2. Memory Statistics in individual session

select granted_memory_kb, used_memory_kb, max_used_memory_kb

from sys.dm_exec_query_memory_grants

where session_id = 60