Navision - SQL Server Performance issue

b2b_Vijay
b2b_Vijay Member Posts: 76
edited 2006-02-15 in NAV/Navision Classic Client
Hi All,

We have a client, who has 120 concurrent Navision Users with very large database size. They have no hardware issues. The main problem is many people try to do transactions, run reports etc and the performance of the system is very low.
Can we split the reports and run in a seperate database? But how is it possible.

I have seen in Microsoft site that we can use NAS server for reporting purposes, but still we have to create buffer tables to transfer the data to reports.(This i found in the Microsoft site)

If in case we split the database into small sizes and place them in different raids, how do i do this? By any chance will it increase the performance.

I have read a lot of articles regarding the performance issues posted in this site, but still i have no answer, so i am again posting an issue on this site.

Please write back if any one has any solutions regarding performance increasing.

Thanx in advance.
Regards,
Vijay

Comments

  • ara3n
    ara3n Member Posts: 9,258
    One suggestion would be to schedule the reports to run at certain times. For example at night. So that users will get their reports through email in the morning.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • kine
    kine Member Posts: 12,562
    1) Have you tried to optimize Keys?
    2) Have you tried to optimize SIFT?
    3) Splitting one big DB file to more Physical discs is good, you have better access time
    4) Size of RAM on your server?
    5) "They have no hardware issues" - how do you know that?

    Thanks... 8)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • DenSter
    DenSter Member Posts: 8,307
    If you don't have your 'large database files' split up into smaller files on a set of RAID arrays, you don't think that is a hardware issue?
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • kriki
    kriki Member, Moderator Posts: 9,121
    kine wrote:
    1) Have you tried to optimize Keys?
    2) Have you tried to optimize SIFT?
    3) Splitting one big DB file to more Physical discs is good, you have better access time
    4) Size of RAM on your server?
    5) "They have no hardware issues" - how do you know that?

    Thanks... 8)
    6) don't use RAID5, but RAID1 or RAID10
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Waldo
    Waldo Member Posts: 3,412
    Here is my opinion:

    - You can schedule anything you want with our NAS Scheduler. More info here: http://www.ifacto.be/default.aspx?page=nasscheduler_eng. But that's enough promotion :wink: .

    - About hardware I can say the following:
    * For 120 concurrent users, use 2-4 CPU's
    * For a big database (+60Gb), use at least 12 seperate harddisks (15K):
      2 in Raid 1 for OS, tempdb and SQL Server installation
      2 in Raid 1 for Transaction Log Files
      --> these should be an a seperate RAID controller
      2 times 4 in RAID10, dividing the data over two seperate database files (you can create extra database files in the enterprise manager).
    * RAM: at least 6 Gb

    Use Enterprise edition of SQL Server!

    These are my recommendations based on my experience. Hope it's useful.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • b2b_Vijay
    b2b_Vijay Member Posts: 76
    Thanx Guys for your response. I think Raid 10 is the best option, i can think as well.

    Thanx a lot for all the info.
    Regards,
    Vijay

Categories