Post reply

how many connections/sessions

  • December 8, 2009 at 4:42 pm

    #214516

    Hi,

    We have SQL Server 2005 64 bit Enterprise Edition in Production. The back end boxes(Tomcat application server) access the database server for insert/update.

    Here, I need to find out how many connections/sesssion from each box. Ideally, how many connections/sessions we can defined for back end boxes to the SQL server.

    I queried the sys.dm_exec_connections and sys.dm_exec_sessions views but I did not get exact values for this issue.

    Please help me to find out the solution.

    Thanks in advance.

  • December 9, 2009 at 4:23 am

    #1089739

    Have you tried the perfmon counter.

    SQL Server:General Statistics >> User Connections

  • December 9, 2009 at 4:51 am

    #1089746

    You can also query this counter

    select * from sys.dm_os_performance_counters where counter_name like '%user connections%'

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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