List of running stored procedures

Is there any way of generating a list of running stored procedures?
--
Thanks, JimHi 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|||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|||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|||thanks, I'll check it out.
--
Thanks, 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,
> 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|||Hi Tracy
sysprocesses only returns nchar(16) for the cmd, DBCC INPUTBUFFER returns
nvarchar(255) for eventinfo.
John
"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
> sysprocesses only returns nchar(16) for the cmd, DBCC INPUTBUFFER returns
> nvarchar(255) for eventinfo.
>
Yes, I know, I was asking the OP if he could get his SPIDs from
sysprocesses as opposed to Profiler...
Tracy McKibben
MCDBA
http://www.realsqlguy.com