Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 559
  • Last Modified:

High Memory usage

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
dimakh
Asked:
dimakh
1 Solution
 
giltjrCommented:
-->  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
 
drawlinCommented:
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
 
Zak-RCommented:

The more visitors are hanging in you server, the more slower you server will be.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Tackle projects and never again get stuck behind a technical roadblock.
Join Now