Trouble in NAV SQL Server

ayashi

Dear all,

I'm having trouble in lookup cust. ledger entry, somehow the Navision seems to process forever ... when I try to use this command :
Select top 1 * from Cust.LedgerEntryTable

The sql keep giving me "executing query batch ..." status, and it seems that the problem exists only for particular table, since other tables are fine.
This causing the posting process can be done too ...

Do you guys know why is this happening ?


Thx before

Waldo

It's very difficult to assist via a forum...

Can you try to run a profiler and see what odd results you get?
I usually use "SP:StmtCompleted", but this might not help you, because the statement doesn't end ... .

Try to see if the statement causes reads. You can also use the performance monitor for this, and see in what way it reads the disk with the database files... .

DenSter

What do you mean 'when you use that command', did you write SQL code yourself, are you running the query from the query analyzer, or is it an issue in the NAV database?

ara3n

add to the top of you query the following statement it will improve the performance

SET TRANSACTION ISOLATION READ UNCOMMITTED


I'm guessing you are writing some report. So the you only doing a read.