Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Slow Console when Scheduling jobs

Updated: 23 May 2010 | 8 comments
Mark Bayliss's picture
0 0 Votes
Login to vote

Hey,

We have Altiris 6.9 + SP1+ MP1 and the Altiris DS is on front server whilst the database is another server running SQL 2005. We are finding that when we drag drop multiple computers on a job folder that has some 30+ jobs with conditions the scheduling process takes a long time.

Any ideas on what might cause this?

Cheers,

Mark

Comments

JoshBauer's picture
06
Jul
2009
1 Vote +1
Login to vote

It is basically down to how

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

Mark Bayliss's picture
30
Jul
2009
0 Votes 0
Login to vote

Sorry for the late reply. The

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

JoshBauer's picture
30
Jul
2009
0 Votes 0
Login to vote

No problem, sorry I couldn't

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

Josh

Timanator's picture
31
Jul
2009
1 Vote +1
Login to vote

We have had the same issue in

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.

JoshBauer's picture
02
Aug
2009
0 Votes 0
Login to vote

Great idea Timanator, But

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.

Timanator's picture
03
Aug
2009
1 Vote +1
Login to vote

No errors noted Josh. And so

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

The KB is : 38917

Phyrant's picture
03
Aug
2009
0 Votes 0
Login to vote

how long?

Just wondering how long it takes.

JoshBauer's picture
03
Aug
2009
0 Votes 0
Login to vote

Well that's great to know,

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

Thanks for your knowledge Tim.

Josh