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.

    Thursday, February 2, 2012 4:19 PM


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)

    Hope this helps.


    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.


    Wednesday, February 15, 2012 10:15 AM