[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SBS 2008 SQL 2005 & MICROSOFT##SSEE Not Releasing Memory

Posted on 2011-03-08
8
Medium Priority
?
1,978 Views
Last Modified: 2012-05-11
I am using Backup Exec 2010 R2 on this SBS 2008 server, and it backs up 20Gbs of data.  It take about an hour and half or even two hours to do so.  I believe the slow down is backing up the System State.  I also need to mention, this is clean install of the OS and Backup Exec 2010 only.  I have all OS services pack and patches applied, and Backup Exec is all up-to-date too.  I noticed the problem is the Windows Internal Database (MICOSOFT##SSEE) sqlservr.exe consumes 4Gbs+ of memory, and does not release the memory unless the Windows Internal Database service is restarted, or the server is rebooted, or if the sqlservr.exe (SQL Server Windows NT -64-bit) process is terminated.  

I decided to implement the max amount of memory to 2147Mbs for both the MSSQL$MICROSOFT##SSEE and SBSMonitoring SQL instances as per the following article:

http://msmvps.com/blogs/bradley/archive/2010/11/08/throttling-the-memory-in-sbs-2008.aspx

I have noticed the sqlservr.exe process now remains active witth a max memory allocation of 2.295,396K.  I am not sure if this actually the best thing to do.   Maybe what should be done is simply leave the default memory settings alone, and simply restart both the SBSMONITORING and MSSQL$MICROSOFT##SSEE services every morning at 5AM.  A simply batch file with the following commands should do, but my concern is I do this will it possibly cause some sort of corruption or problems down the line.  

net stop mssql$sbsmonitoring
net start mssql$sbsmonitoring
net stop mssql$microsoft##ssee
net start mssql$microsoft##ssee

This server installation was done using the defaults.  I am not sure if I should leave the max memory settings as is, or restore the default setting back, or simply restart the services as described above, or even simply leave everything as is.  I just want to new server to run smoothly, and have all the programs get along and place nice with each other.  
0
Comment
Question by:cmp119
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 35071559
it is expected and desired behaviour ...

you want the dbms to utilise all the memory you allocate to it ... and it will do so...
even to the extent of doing extra work in the initial phases aftyer start up to ensure that its buffer pools are
full...

it is up to you DBA/ Server Administrator to consider what the optimal balance is for your system , partiiculaly if you have
multiple instances of a database server running or are sharing the server between the databases and other applications
as to what degree of ram and/or processors you allocate to each service...


0
 
LVL 5

Expert Comment

by:VENKAT KOKULLA
ID: 35872969
It's good to leave the sql as per default settings unless you need them to configure to use a range.
SQL behaves in it's own way like it will take memory what ever it requires and releases the memory if it doesn't require. Please check the dependency of apps running on the sql and check the memory utilization at a peak state.
As you mentioned Sql is not releasing memory... It will be not like the way sql plays, might be some sessions are running on the background in sleeping mode...have you checked..!
so keep sql as per default settings and lets keep an eye on the processes running on the background so that we can figure out which processess are making the sql to utilize more memory, according to that we can necessary action to get this issue resolve......

--Venkat
0
 

Author Comment

by:cmp119
ID: 36007711
I've requested that this question be deleted for the following reason:

I found my own solution.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36000526
>>I found my own solution.<<
Please share it with the EE Community so that we can all learn.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 36007712
The author was provided good feedback, unfortunately they chose not to followup or provide their own solution.
0
 

Accepted Solution

by:
cmp119 earned 0 total points
ID: 36009923
This is a known issue specifically with Windows 2008 Server and Backup Exec 2010 and all previous versions.  This issue was corrected with Backup Exec 2010 R3.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question