Home
»
Discussion Forums
»
Monitoring - VSA
»
SQL Monitoring set problems
Subscribe via RSS
Share this
Similar Posts
SQL Monitor Set
by
LegacyPoster
on
Aug 10, 2006
SQL Query for Monitor-Set / Monitor relationsihps
by
thuque
on
Jul 9, 2015
Verified Answer
MS SQL 2008 ent editon monitor set
by
Chethan kumar N
on
Nov 23, 2012
Not Answered
Need some assistance in creating accurate SQL Views to apply Monitoring Sets
by
allison gilbert
on
Dec 14, 2011
Not Answered
SQL Query Problems
by
Gary Nicholson
on
Dec 16, 2011
View More
Details
1
Reply
0
Subscribers
Posted
over 14 years ago
Monitoring - VSA
SQL Monitoring set problems
Posted by
LegacyPoster
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
You have posted to a forum that requires a moderator to approve posts before they are publicly available.
Posted by
LegacyPoster
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
You have posted to a forum that requires a moderator to approve posts before they are publicly available.