Kompetenz NAV und SQL-Server Performance

Competences

HOME ⁄ Services ⁄ Competences

NAV and SQL Server Performance

We check and optimize your NAV and database servers

The SQL Server Performance Analysis aims to ensure that SQL queries and regular tasks are executed faster and applications are not slowed down unnecessarily. To achieve this, our team checks your database down to the smallest detail to achieve optimal server performance. We have many years of experience in this area and have supported customers with large databases and more than 200 Microsoft Dynamics users in our projects to optimize their servers.

If database systems are no longer checked after installation, performance can decrease and table blockages and locks can occur more often. In addition, individual database files can reach a critical size and the limits of disk capacity can be reached.

At the beginning we define the target state together with you, so that we can determine the optimal configuration of the system.

In the analysis we will deal with the following functions:

•   Hardware
•    Operating system and database version and settings
•    optimum energy management
•    Performance and network
•    regular maintenance tasks with monitoring
•    unnecessary mass data (e.g. based on the largest 20 tables)
•    current database growth including future prognosis
•    SQL index usage and optimization

The analysis is performed with the help of various tools, e.g:

•   SSI Toolkit
•    performance monitor
•    Windows performance monitoring
•    SQL Server Profiler
•    SQL Server Activity Monitor

and usually takes 2-4 hours.

•    a high-performance SQL server with less storage space usage and a future-proof foundation
•    shorter query runtimes, thus fewer blockades and table locks
•    in the end satisfied users and administrators in daily business

Back to the overview

Especially in the following cases the performance analysis has proven to be useful:

•    Excessive logging of table changes using the logic of the change log items: If too much data is logged, this affects performance when writing and reading data.
•    Increased logging in the session event tables due to NAV logons and logoffs, which can cause problems during operation.
•    Too many calculated fields on one list and thus with increasing data volume inperformant NAV lists
•    increased table locks due to non-optimized external SQL queries End satisfied users and administrators in daily business