June 12, 2015 at 6:50 am
I ran the script to generate sp_who3 and it is showing mostly sleeping task with a total of 718 SPID.
I tried multiple versions of this SP and I get the same result.
Any ideas>
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 12, 2015 at 6:59 am
What's the problem? The sleeping tasks? Can you please clarify your issue?
-- Gianluca Sartori
June 12, 2015 at 8:16 am
Any ideas on what? I don't see a problem either.
June 12, 2015 at 8:42 am
And... SP_WHO3 is not a built-in Microsoft sproc. - can you post the DDL you are using to create SP_WHO3?
-- Itzik Ben-Gan 2001
June 12, 2015 at 8:49 am
Just go download Sp_WhoIsActive and use it.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
June 12, 2015 at 8:55 am
Shawn Melton (6/12/2015)
Just go download Sp_WhoIsActive and use it.
+1
Awesome tool!
-- Itzik Ben-Gan 2001
June 12, 2015 at 9:18 am
Shawn Melton (6/12/2015)
Just go download Sp_WhoIsActive and use it.
I already have it and I have been using it for years.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 12, 2015 at 9:19 am
spaghettidba (6/12/2015)
What's the problem? The sleeping tasks? Can you please clarify your issue?
I'm showing task that are still connected but they are not doing anything.
It is acting like sp_who2.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 12, 2015 at 9:21 am
So the question is...?
-- Gianluca Sartori
June 12, 2015 at 9:43 am
spaghettidba (6/12/2015)
So the question is...?
There is no question. There is no spoon either. 😛
Seriously, if you've been using the script for over two years, then certainly you must have gone in a dissected how it works.
You can probably adjust it to filter out the sleeping tasks if you want to.
June 12, 2015 at 9:46 am
How do I get a version that only shows active connections?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 12, 2015 at 10:27 am
Welsh Corgi (6/12/2015)
How do I get a version that only shows active connections?
Well, since most of us may not have the code for sp_who3 it would be hard to tell you how to rewrite it to filter for only active connections. Have you tried to modify the procedure yourself?
June 12, 2015 at 12:04 pm
Lynn Pettis (6/12/2015)
Welsh Corgi (6/12/2015)
How do I get a version that only shows active connections?Well, since most of us may not have the code for sp_who3 it would be hard to tell you how to rewrite it to filter for only active connections. Have you tried to modify the procedure yourself?
That sounds like a predicate in the where clause to me.
Viewing 13 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply