Endpoint Protection

 View Only

  • 1.  SEPM on Windows 2k8 (x64) and MS SQL 2k8 R2 - high mem

    Posted Sep 26, 2011 03:03 AM

    I've noticed that the SEPM server is using most of the memory for MS SQL installed. And through searching, I've found at least 2 websites that explains why:

    http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/08/24/troubleshooting-the-sql-server-memory-leak-or-understanding-sql-server-memory-usage.aspx

    http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/07/07/understanding-the-vas-reservation-aka-memtoleave-in-sql-server.aspx

    It seems that MS SQL handles memory by making calculations on how much physical RAM is available and makes reservations for the available RAM. Which is then locked for MS SQL's use and is only released when there is absolutely no more free RAM available for other processes. This theoretically reduces the query times for the database. So, if the server only contains SEPM and the MS SQL DB, the available RAM will be used up by MS SQL.



  • 2.  RE: SEPM on Windows 2k8 (x64) and MS SQL 2k8 R2 - high mem

    Broadcom Employee
    Posted Sep 26, 2011 03:22 AM

    Thumbs up!

    great info.



  • 3.  RE: SEPM on Windows 2k8 (x64) and MS SQL 2k8 R2 - high mem

    Posted Sep 26, 2011 07:53 AM

    True,

     

    MSSQL will basically "grab as much RAM as it can", resulting in 100% Memory Usage in the Taskmanager.

    Stumbled over that one, too, a while back :-)

     



  • 4.  RE: SEPM on Windows 2k8 (x64) and MS SQL 2k8 R2 - high mem

    Trusted Advisor
    Posted Sep 26, 2011 08:44 AM

    Hello,

    That's an Excellent Info that you have shared.

    Hope this would help all.



  • 5.  RE: SEPM on Windows 2k8 (x64) and MS SQL 2k8 R2 - high mem

    Posted Sep 27, 2011 08:37 PM

    Here's the info I got from Symantec:

    Best practices for the Max Server Memory option in SQL Server

    Article URL http://www.symantec.com/docs/TECH97003

    Which contains a link to Microsoft's KB.

    Just my opinion here. If you're NOT having any problems - i.e. applications are working. Leave it as is.