?
Solved

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

Posted on 2008-10-25
4
Medium Priority
?
681 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 20

Accepted Solution

by:
Marten Rune earned 1000 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 1000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

762 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