Solved

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

Posted on 2008-10-25
4
673 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Query Missing Money orders... 6 67
User profile Size Report 3 36
Calculating Business Hours 19 62
SQL JOIN 6 31
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
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.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

707 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now