Sql Performance

Silva
Silva Member Posts: 281
edited 2008-04-08 in SQL Performance
Hi

We are using SQL Database....but every time we conncet to the SQL SERVER...the performance is very slow...why is that happen..do I need to Adjust/increase the OBJECT CACHE in NAV or It is the SQL server. Hoping for your reply :D

Comments

  • kine
    kine Member Posts: 12,562
    1) If you want some answer, you need to get us much more details - about Hardware, versions of SW (SQL version, NAV version)

    2) Performance on SQL with NAV is one big area of expertise. If you go through the threads about it on this forum, you can create some image of what is needed for you...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • garak
    garak Member Posts: 3,263
    ho, this is to complex for one post ;-)

    Fist, check why the system is slow (you can check this, f.e. with Perfmon, SQL Profiler, also take a look to you C/AL Code, Indexstrukture, SIFTs).
    When you not know, wich counters (perfmon, sql profiler) you must add, sear ch the forum. Under "SQL Performance" and "SQL General" there are many topics about this thema.

    But for more infomation, we need more detail about your problem(s)

    Regards
    Do you make it right, it works too!
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision forum to SQL Performance forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories