<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>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<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 tag
sys.dm_exec_requests
Items 1 to 8 of 8
Using sys.dm_exec_requests to estimate completion time for a process
The following script is used to check on the progress of a database restore, backup and other processes currently executing on SQL Server.
Read more...
By
Smitha Reddy
2011/10/05
|
Source:
SQLServerCentral.com
|
Category:
sys.dm_exec_requests
Rating:
|
Discuss
|
Briefcase
|
1,441 reads
SQL Process % Complete
Display %complete SQL using SYS.DM_EXEC_REQUESTS
Read more...
By
Mehernosh
2011/08/05
|
Source:
SQLServerCentral.com
|
Category:
sys.dm_exec_requests
Rating:
|
Discuss
|
Briefcase
|
1,883 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:
|
Discuss
|
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:
|
Discuss
|
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:
|
Discuss
|
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:
|
Discuss
|
Briefcase
|
4,422 reads
Indepth SPID information
This SP gives you most of the detail you need on a long running query. Simply pass the SPID.
Read more...
By
Amar P
2009/01/09
|
Source:
SQLServerCentral.com
|
Category:
sp_who2
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,821 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:
|
Discuss
|
Briefcase
|
5,568 reads
Items 1 to 8 of 8
Tags
sys.dm_exec_query_plan
(3)
administration
(2)
lock and connection management
(2)
maintenance
(2)
maintenance and management
(2)
performance tuning
(2)
sql server 2005
(2)
sys.dm_exec_sessions
(2)
sys.dm_exec_sql_text
(2)
troubleshooting
(2)
t-sql
(2)
utility
(2)
completion time
(1)
sp_who2
(1)
spid
(1)
sys.dm_exec_connections
(1)
sys.dm_exec_cursors
(1)
sys.dm_tran_session_transactions
(1)
sys.sysprocesses
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
