Post reply

sp_who3 does not show any active processes?

  • March 20, 2015 at 7:36 am

    #302322

    I deployed sp_who3 to a server and it does not show any processes.

    It shoulds at least show the SPID for the EXEC sp_who3 command.

    I'm sysadmin so I do not know why this would not work?

    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/

  • March 20, 2015 at 7:56 am

    #1785353

    sp_who3 is not a built in proc from microsoft.

    my google search found at least four versions in the top ten results, so you'd have to look to the source itself.

    http://sqlserverplanet.com/dba/a-better-sp_who2-using-dmvs-sp_who3

    i see this verison would onyl return items with a valid plan handle, for example, so no idle spids would be shown.

    is that what you might be seeing? no activity/no idle spids?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 20, 2015 at 8:07 am

    #1785355

    I'm pretty sure I saw one version that did not return the SPID that was executing SP_WHO3.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • March 20, 2015 at 8:20 am

    #1785362

    What version of sp_who3 willl show the process that is executing sp_who3?

    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/

  • March 28, 2015 at 11:49 am

    #1787111

    I am a Domain Admin.

    I'm still trying to identify the version of sp_who3 that list the session that is performing the sp_who_3 command.

    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/

  • March 28, 2015 at 1:25 pm

    #1787115

    Google, test, repeat until you find one you like, or adapt one that fits your specific needs.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 28, 2015 at 3:11 pm

    #1787119

    Lowell,

    I have googled and googled.

    I can't find one.

    Do you have a link to one that works?

    Thanks.

    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/

  • March 29, 2015 at 1:27 am

    #1787145

    Welsh Corgi (3/28/2015)

    Lowell,

    I have googled and googled.

    I can't find one.

    Do you have a link to one that works?

    Thanks.

    First result I got was A Better sp_who2 using DMVs (sp_who3)

    😎

    On the tin it says:

    The following code generates the same information found in sp_who2, along with some additional troubleshooting information. It also contains the SQL Statement being run, so instead of having to execute a separate DBCC INPUTBUFFER, the statement being executed is shown in the results.

    Unlike sp_who2, this custom sp_who3 only shows sessions that have a current executing request.

  • March 30, 2015 at 9:29 am

    #1787400

    Eirikur Eiriksson (3/29/2015)

    Welsh Corgi (3/28/2015)

    Lowell,

    I have googled and googled.

    I can't find one.

    Do you have a link to one that works?

    Thanks.

    First result I got was A Better sp_who2 using DMVs (sp_who3)

    😎

    On the tin it says:

    The following code generates the same information found in sp_who2, along with some additional troubleshooting information. It also contains the SQL Statement being run, so instead of having to execute a separate DBCC INPUTBUFFER, the statement being executed is shown in the results.

    Unlike sp_who2, this custom sp_who3 only shows sessions that have a current executing request.

    That version does not show the process that is executing the sp_who3.

    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/

  • March 30, 2015 at 9:41 am

    #1787405

    Welsh Corgi (3/30/2015)

    Eirikur Eiriksson (3/29/2015)

    Welsh Corgi (3/28/2015)

    Lowell,

    I have googled and googled.

    I can't find one.

    Do you have a link to one that works?

    Thanks.

    First result I got was A Better sp_who2 using DMVs (sp_who3)

    😎

    On the tin it says:

    The following code generates the same information found in sp_who2, along with some additional troubleshooting information. It also contains the SQL Statement being run, so instead of having to execute a separate DBCC INPUTBUFFER, the statement being executed is shown in the results.

    Unlike sp_who2, this custom sp_who3 only shows sessions that have a current executing request.

    That version does not show the process that is executing the sp_who3.

    If you evaluate the code you have downloaded then this statement should stand out to you. This is why you are not seeing your current spid (e.g. the spid running who3).

    AND er.session_id != @@SPID

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply