Navision Performance

DynamicUser

HI

My Client is having a Navision 4.0 with SQL Server 2000 And they have very serious problem with performance i was studying the Pdf that is related with performance issue they suggest some fobs
Like
Session Monitor (Navision Server)
Session Monitor (SQL Server)
Activity Log
Sample use of activity log
Client Monitor

From Where i get this ?

or suggest some simple way to solve this issue.

anilkumar

You will get it from Microsoft partner source website.

stryk

The tools you mentioned are known as the "Performance Troubleshooting Tools". IMHO these tools are not quite feasible to investigate and further optimize the performance of a NAV on SQL Server system, as the results could be somewhat "misleading".
If you are looking for NAV based utilities, you should consider the "NAV SQL Server Option Resource Kit" - also available via Partner Source.

According to this, I recommend to use the "Windows Performance Monitor" and "SQL Profiler".

stryk

... and: if you search these forums for "SQL Performance" you will get TONS of useful advice!

DynamicUser

I am not getting "NAV-SQL Server OPtion Resource Kit" on partnersource. Can you send me the link.

Joe_Mathis

It's located here...
http://www.mibuso.com/dlinfo.asp?FileID=561

stryk

Here the Partner Source Link https://mbs.microsoft.com/downloads/partner/navisionna/Microsoft_Navision_SQL_Resource_Kit.zip

Bibo

stryk wrote:

Here the Partner Source Link https://mbs.microsoft.com/downloads/partner/navisionna/Microsoft_Navision_SQL_Resource_Kit.zip

Is this the last version? Maybe someone know if Microsoft have plans to update resource kit? :roll: