Kaseya Community

Home » Discussion Forums » Monitoring - VSA » SQL Monitoring set problems

Learn more about how AuthAnvil can protect and enhance your Kaseya experience

Similar Posts

SQL Monitor Set

by
on Aug 10, 2006

SQL Query for Monitor-Set / Monitor relationsihps

by
on Jul 9, 2015
  • Verified Answer

MS SQL 2008 ent editon monitor set

by
on Nov 23, 2012
  • Not Answered

Need some assistance in creating accurate SQL Views to apply Monitoring Sets

by
on Dec 14, 2011
  • Not Answered

SQL Query Problems

by
on Dec 16, 2011
Details
  • 1 Reply
  • 0 Subscribers
  • Postedover 14 years ago

SQL Monitoring set problems

  • LegacyPoster
    Posted by
    on Jul 1, 2006 7:11 AM
    When we use the SQL monitoring set it sometimes shows an SQL Cache Hits warning with a value of -999. The interval between the warnings is random. The settings are the following:

    Threshold: 90
    Alarm: 85
    Sample Interval: 60
    Description: Should be above 90 %

    The problem cannot be not enough processor power, or not enough memory. The server gets a reboot every morning at 6 AM.

    This is an example of the waring table:

    -999



    12:37:57 26-Jun-06
    -999



    06:09:24 26-Jun-06
    -999



    12:38:01 25-Jun-06
    -999



    11:14:29 25-Jun-06
    -999



    11:14:21 25-Jun-06
    -999



    11:01:52 25-Jun-06
    -999



    10:58:54 25-Jun-06
    -999



    LANtrust


    Legacy Forum Name: SQL Monitoring set problems,
    Legacy Posted By Username: lantrust
  • LegacyPoster
    Posted by
    on Jul 1, 2006 7:11 AM
    -999 means that the system is not picking up the values.. Try opening Perf mon on that machine and see if the object counters are there.

    Legacy Forum Name: Monitor/Event Sets/SNMP Sets,
    Legacy Posted By Username: sourceminer