navision 2009 r2 jobs

Renu1989

hi We scheduled one job in Navision 2009.if the number of records to process is same also it will take different times to complete. sometimes very long time.
Somedays we notice even if large amount of data also it will complete within fewseconds but sometime if less also it will take long time to complete.We findout Table lock as one reason .Sometimes if table lock is not there also it will take time.Kindly someone suggest

allenyyzhou

Hi, Renu1989

Besides table lock, sometimes because the server are running other processes, like other process in NAV, or DB backup. You can use following sql to check what is running in SQL server when it takes time to run your jobs. But if you are using fdb not sql db, i am not sure how to check that, sorry.

SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

David_Singleton

Can you post some details about your system, size, no of users server configuration etc.