Geminiclose
Gemini Password Reset

Please provide your username.

A password reset confirmation email will be sent to your email address.
Username

  • Projects
 
SCHEDULER-287 - Optimize Monitor Mode Query
Estimated: 8 Hours 0 Minutes   Logged: 8 Hours 0 Minutes   Time Left: 0 Hours 0 Minutes
Print  |  Send  |  Refresh  |  Url
  Back to Filter  
Type: Enhancement Enhancement
Priority: Low Low
Severity: Trivial Trivial
Status: Closed Closed
Resolution: Complete
Resources: Bob Denny
Reported By: Bob Denny
Component: Dispatch Scheduler Engine
Fixed In Version: 3.3
Versions Affected: 3.1
Start Date: 11/25/2010
Percent Complete:
Created:  11/6/2009 8:02:43 PM
Revised:
 11/26/2010 6:30:03 PM
Closed:  11/26/2010 6:05:56 PM
Resolved:  11/26/2010 11:15:06 AM

Currently the Monitor Mode query gets all of the plans then looks through them all for those with MonitorInterval > 0. Change this to use a query with MonitorInterval>0 as a constraint in the SQL. This will greatly reduce the overhead, which happens each schedule pass.
Gemini close