Home Forums SQL Server 2005 Administering new 64-bit Sql 2005 Server - integrity check completes then memory spikes 75% and doesnt lower RE: new 64-bit Sql 2005 Server - integrity check completes then memory spikes 75% and doesnt lower

  • Still think i'm being misunderstood, the memory allocated is 24GB this is fine and as expected as its the Max Server Memory...

    The problem is that 75% of that 'allocated' memory is constantly being used i.e. 18GB is in use now by sql server, even though nothing is running. If you look at perfmon logs the sql memory in use never drops on this server..

    Server 32GB

    SQL Allocated 24GB

    SQL In Use 18GB ??

    OS is not using more than a couple ever, and it has 8GB to itself anyhow...

    Oraculum