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

Items 1 to 2 of 2

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 0001/01/01 | Source: SQLServerCentral.com | Category: t-sql

Rating:

Discuss |

Briefcase | 2,994 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 0001/01/01 | Source: SQLServerCentral.com | Category: lock and connection management

Rating:

Discuss |

Briefcase | 4,796 reads

Items 1 to 2 of 2

Scripts with tags Maintenance, Maintenance and Management, Lock and Connection Management

The Ultimate Running Requests Reporter

The Ultimate Connection Summarizer and Trouble Finder