After migration from the SQL server 2000 to SQL 2005 , Navision is slow for the sites that connect to the Database, The site where the server is has no problem when accessing the Database but those from the other sites with the same wide area has a problem accessing the database,
What could be the possible problem if the Latency is not that much , its like 5ms to 10 ms
hope you help me sort this out.
Hi Michael,
welcome to the “Dynamics User Group” [<:o)]
The problem you describe is - unfortunately - not a singular event. NAV/SQL performance issues are frequently (actually permanently) discussed here and I’d like to encourage you to search the forum about “SQL Performance”.
I’m sure you’ll find plenty of useful advices, recommendations, tipps and tricks etc. helping you to solve your problems!
Also look into the BLOG section to get further details, templates and more!
Last but not least: maybe you want to check out this one: http://www.amazon.com/NAV-SQL-Performance-Field-Guide/dp/3837014428/ref=sr_1_1?ie=UTF8&s=books&qid=1255604562&sr=8-1 (new edition will be release in few weeks!)
Best regards,
Jörg