Performance Problem running Nav5.0SP1 on SQL2k8R2

• michael.seifert

  Grasshopper

  Points: 22

  More actions

  March 2, 2011 at 1:02 am

  #246407

  Hello,

  we have a performance issue with our Nav6.0SP1 Database Server.

  After installing two new Server with the same hardware:

  2Processor with 4 Cores an HT

  44GB RAm

  10 SAS Disks

  1Gbit Network

  windows Server 2008 R2 SP1

  SQL Server 2008 R2 CU5

  We enable mirroring for the NAV-Database and start working on it.

  After a couple of time the System Process get 100% of Core3. This occurs every 2.5 Minutes.

  At this time the SQL Server replys very slow. Cause of the same configuration the 2 Server have at the same time this performance tweak.

  What can i do to solve this?

  Thanks for your help.

  Michael

• danschl

  SSCertifiable

  Points: 5770

  More actions

  March 2, 2011 at 9:45 am

  #1293599

  wow someone that actually uses navision

  my company use 3.61 navision itself is capable of flatlining the server