Speed Issues

Business Central/NAV Technical Forum
1

Hi All,

Been at an end user who is experiencing speed issues.

Installed is NAV 2009 SP1, on SQL server 2008

There are two NAV servers trying to balance the load for the RTC users.

There are 102 licensed users in two main buildings on the same site linked by a fibre optic.

Now speed issues may or may not be just NAV related, they could be network related too ie the two NAV servers are actually in a VM environment.

Can anyone recommend performance monitoring tools for the network and for the NAV environment too?

Has anyone else experienced these type of issues?

They have the SQL server setup in recomendation to Stryk’s very good SQL book and his performance guide

http://dynamicsuser.net/blogs/stryk/archive/2009/12/09/the-nav-sql-performance-field-guide.aspx

Any suggestions would be warmly received.

2

Hi,

your friend is SQL profiler and Performance monitor and your system administratior.

G.

3

Degraded performance could have many reasons. I suggest to search the forum and to read NAV/SQL related BLOGS, e.g. starting here [;)] http://dynamicsusers.net/blogs/stryk