Category Archives: DMVs

List of DMV and DMF availability across all SQL Server Versions

This is the extensive list of ALL Dynamic Management Views (DMV) and Dynamic Management Functions (DMF) which are available across Versions and Editions. This List Answers: DMV in SQL Server 2005 DMV newly added in SQL Server 2008 DMV removed in SQL Server 2008 DMV newly added in SQL Server 2008 R2 DMV removed in [...]

SQL Server Management Studio – Client Statistics

SQL Server Client Statistics,Client Execution Time ,Query Profile Statistics ,Number of INSERT, DELETE and UPDATE statements ,Rows affected by INSERT, DELETE, or UPDATE statements ,Number of SELECT statements ,Rows returned by SELECT statements ,Number of transactions ,Network Statistics ,Number of server roundtrips ,TDS packets sent from client ,TDS packets received from server ,Bytes sent from client ,Bytes received from server,Time Statistics ,Client processing time ,Total execution time ,Wait time on server replies ,SQL Server Client Execution Time ,SQL Server Query Profile Statistics ,SQL Server Number of INSERT, DELETE and UPDATE statements ,SQL Server Rows affected by INSERT, DELETE, or UPDATE statements ,Number of SELECT statements , SQL Server Rows returned by SELECT statements , SQL Server Number of transactions , SQL Server Network Statistics , SQL Server Number of server roundtrips , SQL Server TDS packets sent from client , SQL Server TDS packets received from server , SQL Server Bytes sent from client , SQL Server Bytes received from server, SQL Server Time Statistics , SQL Server Client processing time , SQL Server Total execution time , SQL Server Wait time on server replies ,SQL Server 2005 Number of SELECT statements , SQL Server 2005 Rows returned by SELECT statements , SQL Server 2005 Number of transactions , SQL Server 2005 Network Statistics , SQL Server 2005 Number of server roundtrips , SQL Server 2005 TDS packets sent from client , SQL Server 2005 TDS packets received from server , SQL Server 2005 Bytes sent from client , SQL Server 2005 Bytes received from server, SQL Server 2005 Time Statistics , SQL Server 2005 Client processing time , SQL Server 2005 Total execution time , SQL Server 2005 Wait time on server replies ,SQL Server 2008 Number of SELECT statements , SQL Server 2008 Rows returned by SELECT statements , SQL Server 2008 Number of transactions , SQL Server 2008 Network Statistics , SQL Server 2008 Number of server roundtrips , SQL Server 2008 TDS packets sent from client , SQL Server 2008 TDS packets received from server , SQL Server 2008 Bytes sent from client , SQL Server 2008 Bytes received from server, SQL Server 2008 Time Statistics , SQL Server 2008 Client processing time , SQL Server 2008 Total execution time , SQL Server 2008 Wait time on server replies ,sql server Client Stats, sql server 2005 Client Stats, sql server 2008 Client Stats

"Black Box" in SQL Server 2008

In SQL Server 2008, the Default trace is enabled by default during the installation and this default trace in SQL Server 2008 acts as a Black box for the SQL Server. Hence it is also called as "Black Box" in SQL Server 2008 and  the default trace cannot be stopped by using the Query "Exec sp_trace_setstatus 'Trace_id',0 –0 [...]

Find All Queries executed on a particular Table

Question : what all select queries are running against a particular table ? SQL queries used to refer data for a particular table ? Solution : This following script will show you all the queries that have run against a particular table since the last time SQL Server was started. SELECT DISTINCT TOP 500 ProcedureName [...]

Difference between sql_handle and plan_handle

After reading a post about DBCC FREEPROCCACHE with parameters, I got  a lot of question like What is sql_handle? what is plan_handle? How to find sql_handle and plan_handle? What is the difference between a sql_handle and plan_handle? Can we have a example to understand sql_handle and plan_handle ? Let me answer all these question, A [...]

New SQL Server DMV and DMF, which are added in SQL Server 2008

There are lot of new Dynamic Management Views and Dynamic Management Functions are added in SQL Server 2008. Approximately 47 new are got added. Here is the complete list of DMV’s and DMF’s which are added in SQL Server 2008.

How many DMV are available in SQL Server 2008 ?

If you have the following questions, then have landed up the right page How many Dynamic Management Views (DMV) are available in SQL Server 2008 ? How SQL Server DMV are interlinked ? From where these DMV gets the data ? What are the key columns in the DMV? How many Dynamic Management Function (DMF) [...]