locked
Job Scheduling time RRS feed

  • Question

  • Hi Tem,

    I Need to Get the Best time for Scheduling the Job depending on the Server Memory .So,Is there any way i can get these statistics which has details of when the server in past had enough Memory,Space so that i can schedule it @ that time.


    Rakesh M J

    Dont forget to mark it as Answered if found useful

    MCTS,MCITP,MCSS

    http://myspeakonbi.blogspot.com/

    Friday, August 26, 2011 6:09 AM

Answers

  • Use Preformance Monitor to gather statistics and schedule time.

    Creation on execution trigger based on memory used is not effective.

    If task need 5 hours to completet and starts when it detect a low RAM usage, but in half an hour will be started an another task by schedule (like reindex or something like that) - load would be ineffective.

    So i recomment Perormance monitor analysis  and running task in known low memory use window.

    • Proposed as answer by Peja Tao Tuesday, August 30, 2011 3:14 AM
    • Marked as answer by Peja Tao Friday, September 2, 2011 6:58 AM
    Friday, August 26, 2011 7:06 AM