Allocated Memory Alert MSSQL$MICROSOFT##SEE using 1GB RAM

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.

Ya it's a pain isn't it

Download
Microsoft SQL Server Management Studio Express
http://www.microsoft.com/downloads/d...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" <> wrote in message
news:14B9D866-E82B-43C7-92FD-...
> 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.

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/arch...instances.aspx

"gocat2005" <> wrote in message
news:14B9D866-E82B-43C7-92FD-...
> 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.

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/arch...instances.aspx
>
> "gocat2005" <> wrote in message
> news:14B9D866-E82B-43C7-92FD-...
> > 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.
>
> .
>