SQL Server available memory during load test

• GattJ

  SSC Veteran

  Points: 250

  More actions

  July 18, 2013 at 7:00 am

  #296494

  On a Database server, Buffer pool is configured to utilize 80% of RAM and remaining 20% is for OS.

  At the end of Normal load test on the application, database server shows available memory of around 50% on the server.

  However, when application Peak load test is carried out, it starts with available memory of less than 10% on the DB server and then goes down till 7%. And no connections are made to SQL server during this time apart from the peak load test.

  Is this acceptable behavior? Can we have available memory going down until 7% when memory allocated to OS is 20%?

• Geoff A

  SSChampion

  Points: 11511

  More actions

  July 19, 2013 at 6:52 am

  #1633990

  what are the specs of this server? is it 32 bit or 64 bit? how much memory does the server have?

  you give a 80 / 20 settings. so are you saying for example if you have 4 GB of RAM, you gave SQL 3.2 GB?