Solved

High Memory usage

Posted on 2006-11-10
6
549 Views
Last Modified: 2008-01-09
Hi

We are running SQL 2000 server database for our websites.
When we fire any query it is taking lot of memory ( upto 1.7 GB ) and also cpu usage  ( from 40% to 80% )
Because of that sometimes our website is down.
The server is only sql server. No any other application is running on it.
When we restart the sql service it will solve our problem temporarily.
But again same problem arises agin after some time.
Please can you help to solve this issue.

Thanks & Regards
Dimakh
0
Comment
Question by:dimakh
6 Comments
 
LVL 57

Accepted Solution

by:
giltjr earned 20 total points
ID: 17923915
-->  The server is only sql server. No any other application is running on it.

Just to make sure, the Websever is NOT running on the same box as MS SQL Server.  Right?

Depending on the size the database, this could be normal.  Most DBMS attempt to cache as much data in memory as possible.

Is it really any query or is it the same query with different selection criteria?  You may need to tune the query.  Unless you have a huge database it almost sounds as if you may be reading it sequentially.
0
 
LVL 5

Expert Comment

by:drawlin
ID: 17924224
A couple things to check on.  Not sure what OS you are using, but you should optimize memory for background.  Also check pagefile size, should be 150% of physical RAM.  You can also tune the amout of memory you use from within SQL Enterprise Manager.  

Also, I ran across a Microsoft Technet article on SQL memory/pagefile optimization a couple weeks ago but I forget the serch terms I used to get to it.  (I'll keep looking)  They mentioned that you would need to configure page file for a certain size when using a SQL server as a "Something" server.  I can't remember the "something" but I think querys were involved.  You didn't happen to recently add a service or module to your SQL server just before you noticed these problems did you?
0
 
LVL 2

Expert Comment

by:Zak-R
ID: 17956352

The more visitors are hanging in you server, the more slower you server will be.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This is a quick article, and by no means should you quit your job today or plan to feed your family of 5 on a business idea. Starting a business takes work. This article will only give you the basic skeleton of understanding. Going into business for…
If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
The Bounty Board allows you to request an article or video on any technical topic, or fulfill a bounty request to earn points. Watch this video to learn how to use the Bounty Board to get the content you want, earn points, and browse submitted bount…
Where to go on the main page to find the job listings. How to apply to a job that you are interested in from the list that is featured on our Careers page.

790 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