Database Performance

vikram7_dabas
vikram7_dabas Member Posts: 611
edited 2009-03-13 in SQL Performance
Dear concern
one of my client using Navision SQL Database and their database size is 35GB.They have 2GB RAM in server and their Database performance is too slow.Plzz guide me that if I will increase my RAM.Will it improve the performance?
Vikram Dabas
Navision Technical Consultant

Comments

  • garak
    garak Member Posts: 3,263
    Wich OS, Which SQL Server version, Wich SQL Server Edition and yes, 2GB are to too few.
    The OS requ. min 1GB. So you have ~ 750MB only for the SQL Server (the other 250MB are for some other processes ...) Read the also the Hardware REq. for Navision on SQL Server it's on product cd.
    Do you make it right, it works too!
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from 'NAV/Navision' forum to 'SQL Performance' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories