Post reply

Identify Logins per sec SQL Server 2005

  • July 19, 2010 at 1:48 pm

    #148088

    Hi Friends, I need that you help me to identify which logins in my SQL Server 2005 EE 32bits is affecting me;

    I would identify these process usind the profiler, but i don't know which fields select.

    thanks, friends..

  • July 19, 2010 at 2:10 pm

    #1195129

    Hi

    Select "Existing connection" under the "Sessions" event.

    You can also use activity monitor to check the SQL Server connections

    Thank You,

    Best Regards,

    SQLBuddy.

  • July 19, 2010 at 2:17 pm

    #1195135

    Could you describe the problem in more detail. There may be a different solution for the problem.

    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

  • July 19, 2010 at 2:31 pm

    #1195140

    ok thankyou CirquedeSQLeil (Jason) for your answer and to sqlbuddy123 too, well.

    I have the folow issue, i use the Opmanager Monitor, and few week past, the monitor show me the alert that the Logins per sec, Number of Deadlocks per sec and the Average Lock Wait Time is very high... Then. I was searching google and says the reason you find which user logins blocked connections I need to identify which users, then check the conection string and verify the use of pooling and end close conection, because I think the problem is out there, some new reports create the developer team, but I need to have a basis for show and tell the cause of our situation.

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

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