Slow Console when Scheduling jobs

It is basically down to how fast the SQL server can process the information. The more CPU/RAM the faster it is. I have this same problem when scheduling jobs for a lab of 30-33 computers and also when deleting jobs/computers.

Unless it is taking more than 1 min or so to happen then it's normal.

If it worry's you add more RAM, or put it on a faster server.

Josh Bauer

Sorry for the late reply.

The server is pretty well spec'd up. I might need to so some digging to see where the delays and what is causing it.

thanks for the help.

Mark

No problem, sorry I couldn't be more help.

Josh

We have had the same issue in the past. Please try this on your SQL database:

Launch SQl Server Manager and connect to DS database.
Database Properties for each database -> Options

Set Receovery to Simple
and Auto Shrink to True.

Great idea Timanator,

But what does this do to the sql database/ds?

I'm talking about the fact that yes it will speed up the DS console, but have you noted any addtional database errors or issues after setting this?

Having recovery set to Simple (Which I can't seem to find on my list), it really should stay on checksum.

But that is just my understanding.

No errors noted Josh. And so far our job assignment delay issues seems to have disapeared.

The KB is : 38917

Just wondering how long it takes.

Well that's great to know, will go and check that out now.

Thanks for your knowledge Tim.

Josh