locked
SQL connection Pool, how to monitor it? RRS feed

  • Question

  • We have had an issue lately with an application being unable to connect to a SQL database (2008).

    Customer said the app was down but everything showed as up.

    Nothing appeared in any event logs and the issue was resolved by failing over the cluster.

    A posible cause has been put down to no more connections available to SQL.

    Can anyone advise on how I can get SCOM to monitor the SQL connection Pool?

    What do I point SCOM at or do I need the DBA to set something up?

    I am not a DBA just the SCOM guy:)

    Thanks for any suggestions.


    Liamp
    Thursday, February 2, 2012 4:19 PM

Answers

All replies


  • Hi,

    I noticed the following thread which is about monitoring SQL server connectivity. Please see if it can give you some hints:

    Monitor connectivity to SQL server(s)
    http://social.technet.microsoft.com/Forums/en-US/operationsmanagermgmtpacks/thread/bfb8ff93-b706-4578-a9eb-86c953acb479/

    Hope this helps.

    Thanks.


    Nicholas Li

    TechNet Community Support

    • Marked as answer by Nicholas Li Wednesday, February 15, 2012 3:23 AM
    • Unmarked as answer by Liamp Wednesday, February 15, 2012 10:03 AM
    • Marked as answer by Liamp Wednesday, February 15, 2012 10:13 AM
    Wednesday, February 8, 2012 3:20 AM
  • This link was useful as a method of checking SQL connectivty was still working. On investigation into SQL Connection Pools I understand that this is handled within the application code so there is no target to point SCOM at to measure, I have passed the issue back to the applicaton developers to investigate.

    Liamp

    Wednesday, February 15, 2012 10:15 AM