Job Scheduler process becomes slow after upgradation

ajaybabuCh

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

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

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

Native or SQL?

ajaybabuCh

Using SQL.

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

bbrown

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

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.