SQL Server Performance

NAV Performance Problem after Update to Sp3 from SQL Server 2005

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by clma74, May 31, 2010.

  1. clma74 New Member

    Dear Team,
    our customer has performance problems with Microsoft Dynamics NAV after update from Microsoft SQL Server 2005 to SP3:
    Facts:
    - NAV Version: NAV 4.0 Sp3 Update 13 (Build 27256)
    - new SQL Server Version: SQL Server 2005 SP3 (Version 4035) without further Hotfixes

    This customer has about 330 cc Users with a clustered hardware of 4 CPU's with 8 cores. Before the update the CPU's had no hard work. After the update all CPU's work with more than 60% CPU-Useage.
    Could you please help me?
    Best Regards,
    Claudius
    clma74, May 31, 2010
    #2

  2. satya Moderator

    Welcome to the forums.
    Did you check with SP3 readme to see if any specific information has been putup for NAV related issues. Also do you have any support contract with Microsoft in this case to help the customer.
    Drop me an email if you need more help.
    satya, Jun 21, 2010
    #3

Share This Page