Home Forums SQL Server 2008 SQL Server 2008 Administration Memory Leak SQL 2008 R2 64 bit? RE: Memory Leak SQL 2008 R2 64 bit?

  • September 10, 2012 at 8:40 am

    #1535733

    ananda.murugesan (9/10/2012)

    OS - Windows 2008 R2 64 bit (no service pack installed on operating system level)

    SQL - SQL SERVER 2008 R2 64 bit (SP 2 installed)

    One of the dedicated sql server 2008 R2 machine

    Total Server memory - 8 GB

    Max memory setting 6400 MB

    Task manager allways showing - 124 MB by using sqlservr.exe

    In task manager, performance tab,physical memory using 7.5 GB,

    after restarted SQL SERVER services physical memory usages will be reduced and

    currently using 3.5 GB in overall physical memory usages.

    after 10 5 days again increased 7.5 GB in physical memory usages. (80 % used)

    what could be issues in SQL server side?

    also after connecting SQL SERVER Instance not showing Green color, but an instance & database are working fine.

    thanks

    Max server memory only applies to the SQL buffer pool. There are only parts of SQL server which will use an "undefined" amount of memory which will vary depending on the usage.