Solved

SQL 2005 Express - sqlserv.exe memory usage always increasing.

Posted on 2008-10-25
4
675 Views
Last Modified: 2008-11-22
Hi,

I have a server Quad Core 2.4GHz CPU with 2GB Memory. Installed Software Hosting Controller 7C + MS SQL 2005z Express Edition with 4 Websites.

When I start server SQL Memory shows 40MB but, within 1 hour it touches to 290MB and 3-4 hours it goes to 670 or 800MB.

Cause of this sites get slow down and difficult to work on server. Could you please advice where is problem?

Regards,
Dave

0
Comment
Question by:davedhan
4 Comments
 
LVL 20

Accepted Solution

by:
Marten Rune earned 250 total points
ID: 22802389
In SSMSE (Sql Server Management Studio Express), choose view objevt explorer. Connect the desired server, in your case localhost or loca ip or local machine name.
Right click the server and choose properties
In left pane choose memory and in right pane alter Maximum server memory (in MB).

Experiment with different values. Given your posting I would try first with about 512MB.

/Marten
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 total points
ID: 22804769
By default SQL Server will attempt to use all memory available, as it is recommended that it is installed on standalone box.  Since this does not appear to be your case, you will have no choice but to cripple the memory used by SQL Server as suggested above.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

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.
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

810 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