Home   |   Bookmark This Page!

Download SQL Server DMV Client (Dynamic Management Views)



The SQL Server DMV client is a free, light-weight program that allows you to quickly browse through SQL Server DMV and capture crucial performance and operations metrics like current executing queries, blocked queries, CPU time, page reads and writes, and much more.

Download dmvclt.exe (50 kb)

DMV Client supports the following SQL Server DMVs:

sys.dm_exec_connections

The sys.dm_exec_connections DMV provides information about current connections established including sessions executing under the connection, connection time, network protocols, encryption options, authentication mode, number of page reads and writes since connection started, time of last read and last write, network packet size, and client IP address.

sys.dm_exec_sessions

The sys.dm_exec_sessions DMV provides information about current sessions established on the server including login time, application name, data provider, login name, session status, memory used, CPU time and execution time since start of session, number of page reads and writes since start of session, text size, date format, language, SET command settings, transaction isolation level, lock timeout, deadlock priority, rows read, and error codes.

A session can span multiple connections. Likewise, a connection can be reused by different sessions.

sys.dm_exec_requests

The sys.dm_exec_requests DMV provides information about current active queries on the server. This data includes session id, start time, execution status, command type, database id,  connection id, blocking session id, CPU time, wait type, wait time, execution time, reads, writes, open transactions, language, SET command settings, transaction isolation level, lock timeout, deadlock priority, rows read, error codes, percentage completed, estimated completion time, scheduler id, and nesting level.



Tutorials
Building a SQL Server Analysis Services cube

Performing Complete, differential, and log backups

Tuning the tempdb database for performance


Articles
The advent of SQL Server 2005 x64

Understanding SQL Server memory internals

Introducing (DDL) triggers in SQL Server 2005

SQL Server Licensing Explained

Understanding VARCHAR(MAX) in SQL Server 2005


Additional Topics



Copyright © 2008 SQL-Server-Pages.com | Contact US