Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2009

    Unanswered: Issues About server 2003 upgradations...

    Dear Experts,

    We have upgrade the 8gb RAM to 16 gb RAM on windows server 2003 64 bit machine due poor perfomance of server, then what are the steps to follow in sql server 2005?
    Still sql server using only up to 4 gb only when its in heavy work load..

    How to extends the sql server setting for the above configurations....

    Front end Navision and backend as sql server 2005...

    By saravanan.s

  2. #2
    Join Date
    Feb 2003
    Auckland, NZ
    Are you running the 64-bit version of SQL Server 2005? SQL Server won't automatically use all the memory available.

    When you have performance issues it isn't just a matter of throwing RAM at it. Things you can look at is indexes. Are you also re-indexing your database on a regular basis? If you have fragmented indexes this can cause poor performance and table scans.
    Last edited by machado; 03-01-10 at 11:27.
    JJ Kennedy
    Double J IT Solutions

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

  3. #3
    Join Date
    Apr 2009
    I done everything ... the problem is DB size is 260 GB, so we must enhance the RAM , thats a way am asking......

  4. #4
    Join Date
    Jan 2003
    Provided Answers: 11
    As Machado asked, are you running a 32 bit version or a 64 bit version of SQL Server? If you run
    select @@version
    you should see
    Microsoft SQL Server 2005 - 9.00.3042.00 (X64) 
    	Feb 10 2007 00:59:02 
    	Copyright (c) 1988-2005 Microsoft Corporation
    	Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
    If not, then it will only ever be able to take 4 gb of memory. If you have a 64 bit version running, what do you get for the following query:
    exec sp_configure 'max server memory (MB)'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts