Performance tools developed for Dynamic NAV on SQL Server
SQL Perform North America focuses on enhancing the performance of Microsoft Dynamics NAV on Microsoft SQL Server. From performance optimization, to archiving and compression, we have a solution to fix even the most critical and difficult Microsoft Dynamics NAV issues. Our team of Microsoft Dynamics NAV and Microsoft SQL Server specialists proactively take action to eliminate bottlenecks, lock, block, deadlocks and improve your end user experience with Microsoft Dynamics NAV. For over 10 years, SQL Perform has been helping thousands of Microsoft Dynamics NAV and Microsoft SQL Server users increase the performance of their ERP solution. We have offices worldwide and have quickly become globally recognized for our unique set of products, services and expertise.

Proactive Services
We support and assist customers and partners ensuring the optimal performance of Microsoft Dynamics NAV that run on Microsoft SQL Server. We provide our clients with:- Faster project time – so you can focus on your core business
- Lower overall cost – control over your budget and lower overhead costs
- Custom solutions – Performance solutions that meet your business requirements
Why SQL Perform North America?
We Know Dynamics NAV
We are Partner-Friendly
One Stop Performance Solution Provider

Explore our services
Dynamics NAV Performance Audit
Are you looking for a fast and efficient resolution to system bottlenecks?

Analyze
Using our performance tools and proven methodology, we analyze your system looking for performance issues and how efficient processes are running.
Review
Our Dynamics NAV and SQL Server experts review your system and provide you with information that will enable you to effectively fix problems before they start.
Recommend
We create a plan to show you how to approach the performance bottlenecks that may be causing problems. Should you decide to execute our plan, we can help there too.
Get a 360° view of your system
SQL Perform’s Audit Services gives your business a 360 degree system review focusing on performance, system efficiency and preventative care. We will take a holistic look at each major component of your system and examine what can be done to help maximize performance.
Dynamics NAV Archiving & Compression
Is your database bigger than 100GB?
The comprehensive Data Archiving and Compression tools enable IT professionals to store detailed production Dynamics NAV data in an archival database, while moving and/or compressing the data at source. The IT team can select what data will be compressed and moved, and how frequently to archive and compress the data. We have helped organizations reduce their Dynamics NAV databases by hundreds of gigabytes.


Smaller, Better, Faster
Archiving moves the selected data from the primary to historic database while compression not only moves the data, it also replaces the original detail ledger records with new summarized data.
What Can Archiving and Compression Tools Do For Your Business?
Small Operational Database
- Get a solid performance boost of your SQL Server immediately
- Faster reports and processing in Dynamics NAV
Improve Infrastructure
- Less RAM and CPU power
- Minimizes the need for SQL Server Data Compression
- Speedy maintenance
Increase Data Visibility
- Data is kept, but it isn’t clogging the operational database
- Ability to view historic data in archive database
Un-do Functionality
- If anything goes wrong, you can reverse to original state
- Retains detailed data for audit and detailed inspection
Dynamics NAV Performance Tuning
Are you experiencing blocks, time outs or deadlocks?
Microsoft Dynamics NAV offers the growing business a powerful yet cost-effective solution. With the ever growing adoption of a Microsoft SQL Server backend, an ongoing optimized performance environment for your users is critical. With SQL Performance tools, optimizing Dynamics NAV on the SQL Server Platform has never been easier. We offer a fully tested, supported set of tools that ensures the ongoing performance optimization of your database.


20-1000% performance boost compared to non-optimized systems and processes