Foxhound 3.0 FAQ
Foxhound 3.0 FAQ Home      Foxhound Home      RisingRoad           Breck.Carter@gmail.com     


Question: Why is Foxhound taking so long to gather samples?

Answer:

The "Interval" times on the Monitor page should be 10 seconds or close to it, and the "Sample Times" should be less than 1 second

Here is an example where Foxhound is taking longer than normal to gather samples:

                         Heartbeat, 
                          Sample 
     Samples  Interval     Times  
  5:40:56 AM   14.3s    .1s / 13.2s
  5:40:42 AM   12.3s    .1s / 11.3s
  5:40:30 AM   15.9s    .1s / 14.9s

Have a look at the "SPs are OK:" field in the Monitor Status Area at the top of the Monitor page.

If it is showing SPs are OK: NNN or something other than SPs are OK: YYY, try to ensure that the Foxhound's three stored procedures for gathering performance statistics are installed on the target database; see Help - Introduction - Connecting to Target Databases.


This page was last updated on November 14, 2011.      Foxhound 3.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com