Some time Navision will take more time when execute an activity like data up gradation etc. We are not sure the particular activity is going on or not,in this case the following script find out which are the queries running currently on your server and the status of our activity.
SELECT sqltext.TEXT,req.session_id,req.status,req.command,req.cpu_time,req.total_elapsed_timeFROM sys.dm_exec_requests reqCROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
