|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
List of running stored procedures
Is there any way of generating a list of running stored procedures?
-- Thanks, Jim Hi Jim
I assume you mean currently being run, or do you mean are accessed by an application? You could get a list by running profiler for a (long) time but this may not be a complete one. John Show quoteHide quote "Jim" wrote: > Is there any way of generating a list of running stored procedures? > -- > Thanks, Jim John,
We have a lot of procedures that run in batch and some tend to run over 8 hours. I am trying to get a list of what is still running so we can monotor it. -- Show quoteHide quoteThanks, Jim "John Bell" wrote: > Hi Jim > > I assume you mean currently being run, or do you mean are accessed by an > application? You could get a list by running profiler for a (long) time but > this may not be a complete one. > > John > > "Jim" wrote: > > > Is there any way of generating a list of running stored procedures? > > -- > > Thanks, Jim Hi
Profiler would show you the SQL being sent to your server and DBCC INPUTBUFFER may give you the last command for a given SPID. John Show quoteHide quote "Jim" wrote: > John, > > We have a lot of procedures that run in batch and some tend to run over 8 > hours. I am trying to get a list of what is still running so we can monotor > it. > -- > Thanks, Jim > > > "John Bell" wrote: > > > Hi Jim > > > > I assume you mean currently being run, or do you mean are accessed by an > > application? You could get a list by running profiler for a (long) time but > > this may not be a complete one. > > > > John > > > > "Jim" wrote: > > > > > Is there any way of generating a list of running stored procedures? > > > -- > > > Thanks, Jim thanks, I'll check it out.
-- Show quoteHide quoteThanks, Jim "John Bell" wrote: > Hi > > Profiler would show you the SQL being sent to your server and DBCC > INPUTBUFFER may give you the last command for a given SPID. > > John > > "Jim" wrote: > > > John, > > > > We have a lot of procedures that run in batch and some tend to run over 8 > > hours. I am trying to get a list of what is still running so we can monotor > > it. > > -- > > Thanks, Jim > > > > > > "John Bell" wrote: > > > > > Hi Jim > > > > > > I assume you mean currently being run, or do you mean are accessed by an > > > application? You could get a list by running profiler for a (long) time but > > > this may not be a complete one. > > > > > > John > > > > > > "Jim" wrote: > > > > > > > Is there any way of generating a list of running stored procedures? > > > > -- > > > > Thanks, Jim Jim wrote:
> John, Can you get what you need by querying the sysprocesses table?> > We have a lot of procedures that run in batch and some tend to run over 8 > hours. I am trying to get a list of what is still running so we can monotor > it. Hi Tracy
sysprocesses only returns nchar(16) for the cmd, DBCC INPUTBUFFER returns nvarchar(255) for eventinfo. John Show quoteHide quote "Tracy McKibben" wrote: > Jim wrote: > > John, > > > > We have a lot of procedures that run in batch and some tend to run over 8 > > hours. I am trying to get a list of what is still running so we can monotor > > it. > > Can you get what you need by querying the sysprocesses table? > > > -- > Tracy McKibben > MCDBA > http://www.realsqlguy.com > John Bell wrote:
> Hi Tracy Yes, I know, I was asking the OP if he could get his SPIDs from > > sysprocesses only returns nchar(16) for the cmd, DBCC INPUTBUFFER returns > nvarchar(255) for eventinfo. > sysprocesses as opposed to Profiler...  
Other interesting topics
except keyword
Need help troubleshooting a memory paging issue Drop table , procedure Problems Spid checker query help limited permissions on test server for developers Low Disk Space Delete records in a table with 15 dependencies how to remove the sql server registry mess? CHECKING the TRANSACTION LOG Remote Production Database Issue |
|||||||||||||||||||||||
