Post reply

Sleeping hundreds of "Microsoft SQL Server Management Studio - Transact-SQL IntelliSense" SPIDS

  • December 22, 2011 at 4:47 am

    #253919

    Hi,

    today when i checked active processes using sp_who2 i came across there are hundereds of SPID's in sleeping mode and which is showing programName as Microsoft SQL Server Management Studio - Transact-SQL IntelliSense" , I killed them once but again they get regenerated.

    Can anyone help me with this to how to get rid of it.

    Thanks In Advance

    Vineet Bhargava.,

    Thanks And Regards
    Vineet Bhargava
    vineetbhargav@gmail.com

  • December 22, 2011 at 5:27 am

    #1424732

    wierd, on my 2008 server all my connections from SSMS say "Microsoft SQL Server Management Studio - Query" or

    "Microsoft SQL Server Management Studio" ...none reference intellisense.

    do you have a lot of developers connecting to your server via SSMS? is this 2008R2? maybe there's a connection for each window a developer has open?

    for example 6 windows per developer x 10 developers = 60 idle connections form SSMS? looking at the hostname in sp_who2,

    are they all from a single machine, or from a lot of dev machines?

    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!

  • December 22, 2011 at 11:52 pm

    #1425028

    Thanks Lowell For your reply.

    No none of the developers are connected....as the database it is showing we are not using it as well as i killed all the processes but still its shooting up adn i dont know why this is happening..

    even i'm not able to find much information on google as well related to this.

    yes i'm using sql server 2008 r2.

    thanks

    vineet bhargava

    Thanks And Regards
    Vineet Bhargava
    vineetbhargav@gmail.com

  • December 23, 2011 at 6:07 am

    #1425125

    run sp_who2 again...based on the hostname column, is it all from a single machine, maybe even your own machine, since that's the only one you KNOW is running SSMS?

    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!

Viewing 4 posts - 1 through 3 (of 3 total)

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