Monthly Archives: July 2007

Report Blocker and Blockee (Waiter) SQL Statements

Report Blocker and Waiter SQL Statements Description Sample stored procedure that reports real time blocker and waiter SQL statements. This stored procedure, which requires Microsoft SQL Server 2005, lists real time blocks, including the blocked statement and the blocker. Script … Continue reading

Posted in SQL Server 2005 Scripts | 29 Comments

List Real-Time Blocker and Waiter Statements

List Real-Time Blocker and Waiter StatementsDescriptionSample script that lists real-time blocker and waiter SQL statements. This script requires Microsoft SQL Server 2005.  Script Code  select t1.resource_type ,db_name(resource_database_id) as [database] ,t1.resource_associated_entity_id as [blk object] ,t1.request_mode ,t1.request_session_id — spid of waiter ,(select … Continue reading

Posted in SQL Server 2005 Scripts | 20 Comments

Compare Signal Waits and Resource Waits

Compare Signal Waits and Resource Waits Description Sample script that compares signal waits and resource waits. Signal waits are the time spent in the runnable queue waiting for the CPU, while resource waits are the time spent waiting for the … Continue reading

Posted in SQL Server 2005 Scripts | 14 Comments

List Currently-Executing Statements

List Currently-Executing Statements Description Sample script that lists currently-executing statements. A status equal to runnable indicates that the user waiting on the CPU. Note that each scheduler has its own runnable queue. This script, contributed by Microsoft’s Tom Davidson, requires … Continue reading

Posted in SQL Server 2005 Scripts | 39 Comments

What is new in SQL Server 2008.

The following documents details about what is new in SQL Server 2008.   SQL Server 2008 Product Overview http://www.microsoft.com/sql/techinfo/whitepapers/sql2008overview.mspx http://download.microsoft.com/download/a/c/d/acd8e043-d69b-4f09-bc9e-4168b65aaa71/SQL2008_ProductOverview.doc  

Posted in SQL Server 2008 | 30 Comments

DMVStats – Performance Datawarehouse Application

DMVstats 1.0 – A SQL Server 2005 Performance Data Warehouse Application Author:         Tom Davidson Reviewer:      Sanjay Mishra   Introduction Microsoft SQL Server 2005 provides Dynamic Management Views (DMVs) to expose valuable information that you can use for performance … Continue reading

Posted in SQL Server 2005 | 27 Comments

Buffer pool: Look at the contents of Buffer Pool

Buffer Management http://msdn2.microsoft.com/en-us/library/aa337525.aspx http://blogs.msdn.com/sqlperf/default.aspx The following script give you the info about buffer pool and written by "Data & SQL Storage Performance Team" select        count(*)as cached_pages_count,        obj.name as objectname,        ind.name as indexname,        obj.index_id as indexid from … Continue reading

Posted in SQL Server Scripts | 21 Comments