NAV Performance Problem after Upgrade to NAV2009SP1 and SQL Server 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

NAV Performance Problem after Upgrade to NAV2009SP1 and SQL Server 2005

I recently upgraded my client from NAV3.7 to NAV2009SP1 and SQL Server 2005 (9.00.5000.00). However, Client is experiencing some performance issues with certain Account Schedule reports in NAV.
I have checked the keys in NAV to make sure the correct keys are used to get better performance but still having performance issues..
Any help is appreciated.

Welcome to the forums.
As you say the performance is hampered during the reports are pulled out from NAV, this means you have to go through the logs and information that you may have for this behaviour.
I believe you have to go through a detailed plan of monitoring the performance issue, such as monitor the SQL Server platform for CPU, Memory, disk and query statistics usage. You can take help of Performance Dashboard reports from SQL Server Management studio that will highlight the resource usage on the server. It is also ideal to involve the NAV perspective to see how the queries are executed when the reports are pulled over.


Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |