Post reply

no.of concurrent connections to SQL instance

  • May 27, 2010 at 10:22 am

    #387032

    Hi,

    We have SQL Server 2005 and want to know the no.of concurrent connections to SQL instance

    thanks

  • May 27, 2010 at 10:45 am

    #1173454

    run sp_who or sp_who2;

    every spid greater than 50 is a user connection.

    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!

  • May 27, 2010 at 11:26 am

    #1173477

    This is a spot count. If you want to know the max, you need to keep track of this over time, grabbing the total count at various times.

  • May 27, 2010 at 11:46 am

    #1173488

    I prefer using the DMV's for this sort of thing now. To monitor connections I'd use sys.dm_exec_connections and sys.dm_exec_requests. You can combine those with other DMV's to get a lot more information.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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