Browse by Tags

SQL Server: Quick way to find Active & idle connections on a SQL instance

Published 2 May 8 4:32 AM | SSQA.net

Using SQL Server 2005 you can take help of DMV - sys.dm_exec_connections that will give server-level information about the connections. In the olden days usage of sysprocesses system table used to be heavy and same approach can be achieved by using system...

Filed under: sql server, dmv, transaction, connections, tsql, sysprocesses, active

SQL Server 2008 - TSQL behavioural changes and enhancements

Published 31 March 8 2:0 PM | SSQA.net

As usual the new release of SQL Server version 2008 had few changes from 2000 to 2005 and as usual this control-of-flow sequence should occur in order to take advantage of performance with transaction/rollback advantages. Such direction of flow should...

Filed under: sql server, performance, transaction, article, 2008, tsql, enhancement, begin

FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: "New request is not allowed to start because it should come with valid transaction descriptor"

Published 23 August 7 6:25 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, kba, transaction, enterprise, x64, stored procedure, tsql

TSQL to identify the transaction with the most locks

Published 31 July 7 9:25 AM | SSQA.net

SELECT request_session_id, COUNT (*) num_locks FROM sys.dm_tran_locks GROUP BY request_session_id ORDER BY count (*) DESC...( read more ) Read More...

Filed under: sql server, performance, transaction, tsql, locks