NAVISION 4.0 SP3 WITH SQL SERVER 2005 SP3

davidamil
davidamil Member Posts: 2
edited 2009-06-18 in SQL Performance
HELLO.

WE HAVE UPGRADED SQL SERVER 2005 SP2 WITH HOTFIX 11 TO SQL SERVER 2005 SP3 AND THE PERFORMANCE OF THE SQL HAVE FALLEN IN A WAY THAT IS ALARMING (WITH ONE USER, IT TAKES MORE THAN 1 MINUTE REGISTERING A TRANSFER BETWEEN WAREHOUSES).

ANY SUGGESTIONS???????

Comments

  • ara3n
    ara3n Member Posts: 9,258
    run query profiler and see which statement are taking long.
    Are you running nightly updates of indexes?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV/Navision' forum to 'SQL General' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    We migrated two smaller customers to SP3 to get a feeling about it and we also upgraded our performlab servers. So far we have not seen any issues.

    This does not mean there are not any, but AFAIK SP3 is just a cumulative hotfix called servicepack.

    Please run the Navision client monitor during a transaction that is slow. It seems to me that it is very reproducive.
    Marije Brummel | Freelance Business Central Specialist
  • Stryke69
    Stryke69 Member Posts: 7
    Have a look at http://msdn.microsoft.com/en-us/library/dd353312(SQL.90).aspx. There it is said:
    SQL Server 2005 SP3 contains the hotfixes that were included in cumulative update packages for SQL Server 2005 Service Pack 2 from cumulative update package 1 to cumulative update package 9.
    Note: If you are upgrading from SQL Server 2005 SP2 Cumulative Update 10 or Cumulative Update 11, you must apply a post-SP3 cumulative update after upgrading to SP3 to get all the fixes. This post-SP3 update is available at http://support.microsoft.com/kb/959195/.

    Maybe you have to install the post-SP3 cumulative updates mentioned.

Categories