November 19, 2010 at 12:17 am
Hi I am new to SQL server Scheduler. I would like to know if there is any benchmark or data on the scheduler's performance. I am trying to evaluate if we can run several 100s of schedules simultaneously with different time intervals.
November 19, 2010 at 1:28 am
What is scheduler?
Do you mean the scheduler which is mapped to logical CPU? or something else?
November 19, 2010 at 1:55 am
Mukunth-444251 (11/19/2010)
Hi I am new to SQL server Scheduler. I would like to know if there is any benchmark or data on the scheduler's performance. I am trying to evaluate if we can run several 100s of schedules simultaneously with different time intervals.
Did you mean SQL Server Agent jobs? Read this for an overview on SQL Server Agent.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 19, 2010 at 9:45 am
Do you want to schedule/run different SQL server agent job on different or same time ?
Kindly explain a bit more your scenario.
November 20, 2010 at 2:05 am
there may be few jobs running simultaneously (few 10s) and rest of the jobs may be staggered over a period of a day
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply