Job Scheduler process becomes slow after upgradation

ajaybabuCh · 2011-02-10

Hi All,

We have done a technical upgrade from Navisoin 4.x to Dynamics Nav 2009 SP1.
Customer using Classic even in Nav 2009 SP1.

Customer has a job scheduler which runs very faster when they were using 4.x.
Now the same Job Scheduler process with Nav 2009 SP1 has slowed down to crawl.

Can anybody suggest the solution.

Thanks and Regards
Ajay

ta5 · 2011-02-10

Hi Ajay
I guess it is not a problem of the scheduler but a general problem with that job. Do you use sql or native database?
Thomas

bbrown · 2011-02-10

Version 4.x had Job Scheduler. Which ran from a NAV client. Version 2009 has Job Queue. Which runs under NAS. Apples and Oranges. Which are we talking about?

And yes, it could be the process itself. What is the job doing?

kine · 2011-02-10

Native or SQL?

ajaybabuCh · 2011-02-11

Using SQL.

We did only technical upgrade. So we are using Nav 4.x job scheduler objects only with Nav 2009 classic client.

bbrown · 2011-02-11

The big difference between 4.x and 2009 SQL was the introduction of VSIFT (indexed views) back in the prior version. Index views were an improvement to write performance over the old SIFT (used by versrion 4) but in some cases has slower read performance.

So the issue may not be Job Scheduler at all, but rather that the process being run may need to be tuned for the new DB structure.

kine · 2011-02-11

1) Check, if indexhinting is disabled
2) Which version of SQL?
3) Each version use the DB in different ways, needing different index optimization, need or do not need to maintain auto stats etc.

Job Scheduler process becomes slow after upgradation

Comments

Categories