Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Setup / May 2006

Tip: Looking for answers? Try searching our database.

sqlservr.exe High memory usage that keeps growing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SBSnewbie - 08 Jun 2005 18:34 GMT
I've noticed on our SBS 2003 premium server that the sqlservr.exe process
never lessens it's memory usage but instead continually adds to it.  
Currently it is at 1,451,184k!!  

How do I correct this?  

When I run tasklist /svc from the command prompt, I get the following PID
info if that is helpful.

Image Name                PID          Service

sqlservr.exe                 2172        MSSQL$BKUPEXEC
sqlservr.exe                 2420        MSSQL$SBSMONITORING
sqlservr.exe                 2436        MSSQL$SHAREPOINT
sqlservr.exe                 2616        MSSQLSERVER

Rebooting the server solves the problem for the a few weeks but that is not
something this is obviously not a good long-term solution.  

Thanks in advance for any help on this matter.
Mike Epprecht \(SQL MVP\) - 08 Jun 2005 19:55 GMT
http://support.microsoft.com/default.aspx?scid=kb;en-us;321363

Signature

--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

> I've noticed on our SBS 2003 premium server that the sqlservr.exe process
> never lessens it's memory usage but instead continually adds to it.
[quoted text clipped - 17 lines]
>
> Thanks in advance for any help on this matter.
SBSnewbie - 08 Jun 2005 20:38 GMT
Thank you.  I'll check that out.

"Mike Epprecht (SQL MVP)" wrote:

> http://support.microsoft.com/default.aspx?scid=kb;en-us;321363
>
[quoted text clipped - 19 lines]
> >
> > Thanks in advance for any help on this matter.
DDigweed - 29 May 2006 15:06 GMT
I have this exact same issue.  The server genereates memory warning alerts
because of this, every week or so.  How do you set the min/max memory with
the tools available in SBS2003?  There appears to be no SqlServer tools?

> Thank you.  I'll check that out.
>
[quoted text clipped - 23 lines]
> > >
> > > Thanks in advance for any help on this matter.
Keith Kratochvil - 30 May 2006 21:54 GMT
Can you use osql.exe (a DOS-level tool) to connect to the database server
and execute the appropriate sp_configure statement?

Signature

Keith Kratochvil

>I have this exact same issue.  The server genereates memory warning alerts
> because of this, every week or so.  How do you set the min/max memory with
[quoted text clipped - 30 lines]
>> > >
>> > > Thanks in advance for any help on this matter.
DDigweed - 31 May 2006 13:37 GMT
Yes, thanks Keith, thats what I finally did.  I'm new to the 2003 SBS server,
and was surprised how difficult it was to find this answer.

I asumed that SBS was supposed to be easy(ier) for a Small Business Customer
to manage.  This issue started a couple weeks after the packaged Dell server
was installed, and repeats every week, sending out badly formatted warning
messages that cause the customer to be concerned that his server will crash.

There is no way for the customer to resolve this without some fairly expert
help.  Having to go in and "tune" the memory useage of SQL server using a
text-based tool like osql just seems to defeat the whole purpose of the SBS
product.  

Wondering if the problem might be a Dell install issue, as another thing
they did is create one tiny and one huge partition on the disk array, and
then installed all components of SBS on the tiny partition.  Within days
after the install the customer was getting low disk space warnings cause by
the Exchange email store......

> Can you use osql.exe (a DOS-level tool) to connect to the database server
> and execute the appropriate sp_configure statement?
[quoted text clipped - 33 lines]
> >> > >
> >> > > Thanks in advance for any help on this matter.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.