mibuso.com
Home› SQL General
Options

Trouble in NAV SQL Server

ayashiayashi Member Posts: 78
edited 2007-05-15 in SQL General
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
hairstyles

Comments

  • Options
    WaldoWaldo Member Posts: 3,412
    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... .

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    DenSterDenSter Member Posts: 8,304
    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?
    Daniel Rimmelzwaan
    RIS Plus, LLC
    MVP - Business Apps
  • Options
    ara3nara3n Member Posts: 9,255
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.