Solved

High Memory usage

Posted on 2006-11-10
6
544 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
Comment Utility
-->  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
Comment Utility
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
Comment Utility

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

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

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…
Since 2008, the stock markets have been in a haphazard state of fluctuation. At times it has been a steep decline (2008) and at others, a steady incline full of promise (2010). Just weeks ago, in August 2011, together we saw the stock markets plunge…
Notifications on Experts Exchange help you keep track of your activity and updates in one place. Watch this video to learn how to use them on the site to quickly access the content that matters to you.
Articles on a wide range of technology and professional topics are available on Experts Exchange. These resources are written by members, for members, and can be written about any topic you feel passionate about. Learn how to best write an article t…

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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now