Allocated Memory Alert MSSQL$MICROSOFT##SEE using 1GB RAM
|
Prev: How do I configure companyweb (WSS 3.0 / SBS 2008) for external account
Next: Long filenames not supported..
From: gocat2005 on 2 Jul 2010 09:36 Hello I keep getting an allocated memory alert for an instance of MSSQL$MICROSOFT##SEE. It is using 906,544 memory on a 4GB box. What is this database and why is it doing this? It has been happening for a few months but is getting more regular. Rebooting the server clears the problem for a week or two. SBS 2003 Premium R2 fully up to date with all service packs and updates.
From: Russ (SBITS.Biz) [SBS-MVP] on 2 Jul 2010 15:02 Ya it's a pain isn't it :) Download Microsoft SQL Server Management Studio Express http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en Connect to the database \\.\pipe\mssql$microsoft##ssee\sql\query and Adjust the "Memory" usage Russ -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Remote Small Business Server/Computer Support - www.SBITS.Biz BPOS - Microsoft Online Services - www.BPOSMadeEasy.com Easy Redirect to Microsoft's New SBS Public Forum - www.SBSRepair.com "gocat2005" <gocat2005(a)discussions.microsoft.com> wrote in message news:14B9D866-E82B-43C7-92FD-2B8E3E3EF909(a)microsoft.com... > Hello > > I keep getting an allocated memory alert for an instance of > MSSQL$MICROSOFT##SEE. It is using 906,544 memory on a 4GB box. > > What is this database and why is it doing this? It has been happening for > a > few months but is getting more regular. > > Rebooting the server clears the problem for a week or two. > > SBS 2003 Premium R2 fully up to date with all service packs and updates.
From: Paul Shapiro on 5 Jul 2010 10:24 SQL Server will take up memory as long as it can use it and memory is available. It's supposed to release the memory when the system experiences memory pressure, but that part doesn't always happen. If this post doesn't address your exact problem, you should be able to find instructions more directed at your issue by searching. http://msmvps.com/blogs/bradley/archive/2007/12/25/adjusting-sql-embedded-instances.aspx "gocat2005" <gocat2005(a)discussions.microsoft.com> wrote in message news:14B9D866-E82B-43C7-92FD-2B8E3E3EF909(a)microsoft.com... > Hello > > I keep getting an allocated memory alert for an instance of > MSSQL$MICROSOFT##SEE. It is using 906,544 memory on a 4GB box. > > What is this database and why is it doing this? It has been happening for > a > few months but is getting more regular. > > Rebooting the server clears the problem for a week or two. > > SBS 2003 Premium R2 fully up to date with all service packs and updates.
From: gocat2005 on 7 Jul 2010 04:35
Thanks guys. I have SQL Server Workgroup Edition on the server so I already had the management studio. This seems to confim my suspicion that WSUS 3 has been causing this issue ever since it was "upgraded". I set the max memory for the instance to 300MB and will see if that solves the issue. I guess it will. "Paul Shapiro" wrote: > SQL Server will take up memory as long as it can use it and memory is > available. It's supposed to release the memory when the system experiences > memory pressure, but that part doesn't always happen. > > If this post doesn't address your exact problem, you should be able to find > instructions more directed at your issue by searching. > http://msmvps.com/blogs/bradley/archive/2007/12/25/adjusting-sql-embedded-instances.aspx > > "gocat2005" <gocat2005(a)discussions.microsoft.com> wrote in message > news:14B9D866-E82B-43C7-92FD-2B8E3E3EF909(a)microsoft.com... > > Hello > > > > I keep getting an allocated memory alert for an instance of > > MSSQL$MICROSOFT##SEE. It is using 906,544 memory on a 4GB box. > > > > What is this database and why is it doing this? It has been happening for > > a > > few months but is getting more regular. > > > > Rebooting the server clears the problem for a week or two. > > > > SBS 2003 Premium R2 fully up to date with all service packs and updates. > > . > |