Databases Reference
In-Depth Information
Figure 11-1.
Capturing a statement's performance metrics
Next, open another query window, which opens a new connection in SQL Database. Run the following query
(see Figure
11-1
), and make sure to specify the session ID being investigated:
SELECT
login_time,
host_name,
program_name,
host_process_id,
cpu_time,
memory_usage,
total_elapsed_time,
reads,
writes,
logical_reads,
row_count,
original_login_name
FROM sys.dm_exec_sessions
WHERE session_id = 176 // replace with your session_id
This statement returns important performance metrics for your previous SQL statement, as explained in
Table
11-3
.
