SQLServerCentral: Content tagged Maintenance and Management, Lock and Connection Management

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Content with tags Maintenance and Management, Lock and Connection Management

Items 1 to 20 of 45 Next 20 >>

The Ultimate Running Requests Reporter

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan. Read more...

By Jesse Roberge 2010/05/24 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 4,422 reads

The Ultimate Running Requests Reporter

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan. Read more...

By Jesse Roberge 2010/05/24 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 4,422 reads

The Ultimate Connection Summarizer and Trouble Finder

Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group. Read more...

By Jesse Roberge 2009/10/22 | Source: SQLServerCentral.com | Category: lock and connection management

Rating:

|

Briefcase | 5,568 reads

The Ultimate Running Requests Reporter

Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan. Read more...

By Jesse Roberge 2010/05/24 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Briefcase | 4,422 reads

The Ultimate Connection Summarizer and Trouble Finder

Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group. Read more...

By Jesse Roberge 2009/10/22 | Source: SQLServerCentral.com | Category: lock and connection management

Rating:

|

Briefcase | 5,568 reads

How to insert and update from remote linked server

Please read the how to use. unfortunately the orignal document i submitted was truncated :( and i dont have time to remember what i said Read more...

By Chris Morton 2007/10/30 | Source: SQLServerCentral.com | Category: replication

Rating:

|

Briefcase | 2,512 reads

usp_KillConnections

By Antonio Pedrosa 2007/10/19 | Category: lock and connection management

Rating:

|

Briefcase | 8,880 reads

usp_KillConnections

By Antonio Pedrosa 2007/10/19 | Category: lock and connection management

Rating:

|

Briefcase | 8,880 reads

finding the blocks in sql server

By Paarthasarathy 2013/05/21 | Category: miscellaneous

Rating:

|

Briefcase | 3,449 reads

SP_WHO_3 Powerful Filtering/Sorting Very Efficient

By Additional Articles 2007/06/13 | Category: miscellaneous

Rating:

|

Briefcase | 1,629 reads

What's Running

By Eric Wahner 2007/04/17 | Category: lock and connection management

Rating:

|

Briefcase | 2,483 reads

SP_WHO_3 Powerful Filtering/Sorting Very Efficient

By Additional Articles 2007/06/13 | Category: miscellaneous

Rating:

|

Briefcase | 1,629 reads

sp_what

By Andrew Stanton 2006/10/02 | Category: lock and connection management

Rating:

|

Briefcase | 1,888 reads

Function to return the SQL Build Number

By Andy B. 2006/08/09 | Category: replication

Rating:

|

Briefcase | 953 reads

Function to return the SQL Version Number

By Andy B. 2006/08/08 | Category: replication

Rating:

|

Briefcase | 1,189 reads

Function to return the SQL Build Number

By Andy B. 2006/08/09 | Category: replication

Rating:

|

Briefcase | 953 reads

Function to return the SQL Version Number

By Andy B. 2006/08/08 | Category: replication

Rating:

|

Briefcase | 1,189 reads

sp_what

By Andrew Stanton 2006/10/02 | Category: lock and connection management

Rating:

|

Briefcase | 1,888 reads

SP_WHO_3 - A Very Powerful Utility for All DBAs

By Additional Articles 2006/01/17 | Category: miscellaneous

Rating:

|

Briefcase | 1,636 reads

Save results DBCC SQLPERF(UMSSTATS) in a table

By Robbert Hof 2005/11/04 | Category: lock and connection management

Rating:

|

Briefcase | 1,784 reads

Items 1 to 20 of 45 Next 20 >>