Navision - SQL Server Performance issue

b2b_Vijay

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.

ara3n

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.

kine

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)

DenSter

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?

kriki

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

Waldo

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 .

- 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.

b2b_Vijay

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.