http://blogs.microsoft.co.il/blogs/dannyr/archive/2008/10/07/getting-blocking-info-in-sql-server-2005-amp-2008-the-easy-way.aspxmanagement studio :-- connection 1 use AdventureWorks go begin tran update Person.Contact set Phone = '99999'this will upd

http://glennberrysqlperformance.spaces.live.com/?_c11_BlogPart_BlogPart=blogview&_c=BlogPart&partqs=cat%3dSQL%2520Server%252020052010/10/20SQL Server 2005 Diagnostic Information QueriesIthas been a while since I posted the SQL Server 2005 version of this

<br />http://www.mssqltips.com/tip.asp?tip=1949<br />Problem<br />I get so frustrated when trying todetermine where to start when a user comes to me and tells me that "thedatabase is slow".  Launching Performance Monitor and running a trace in Prof

<br />http://www.sqlskills.com/BLOGS/PAUL/category/Performance.aspx<br /> <br />Here are 1823 SQL Servers wait state survey result.<br /> <br /><br /> <br /> 505: CXPACKETThis is commonly where a query is parallelized and the parallel threads are not given

CXPACKET<br />http://www.confio.com/English/Tips/Sql_Server_Wait_Type_CXPACKET.php<br />The SQL Server CXPacket waittype isinvolved in parallel query execution. It indicates that the SPID iswaiting on a parallel process to complete or start. The CXPack

SQL Server Wait Type PAGEIOLATCH_EX<br />http://www.confio.com/English/Tips/Sql_Server_Wait_Type_PAGEIOLATCH_EX.phpDefinition<br />In SQL Server, a latch is a short-term lightweight synchronization object.<br />Bufferlatches including wait type Pageiolat

SQL Server Wait Type OLEDBhttp://www.confio.com/English/Tips/Sql_Server_Wait_Type_OLEDB.phpDefinitionOLEDBis a common wait type in SQL Server, indicating a significant amout ofwait time accumulation. Is it a problem This waittype indicates that anSPI

ASYNC Network IO<br />http://www.confio.com/English/Tips/Async_Network_IO.php<br />The “async network io” (in SQL2005/2008) and “networkio” (in SQL 2000) wait types can point tonetwork related issues, but most often are caused by a clientapplication