Advertisement

11.10.2006 at 07:48PM PST, ID: 22056942
[x]
Attachment Details

High Memory usage

Asked by dimakh in Miscellaneous

Tags: high, usage, memory, sql

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
Start Free Trial
[+][-]11.11.2006 at 06:58PM PST, ID: 17923915

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Miscellaneous
Tags: high, usage, memory, sql
Sign Up Now!
Solution Provided By: giltjr
Participating Experts: 3
Solution Grade: A
 
 
[+][-]11.11.2006 at 09:52PM PST, ID: 17924224

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.16.2006 at 07:12AM PST, ID: 17956352

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.12.2007 at 12:56AM PST, ID: 18299787

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]01.12.2007 at 12:57AM PST, ID: 18299792

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]01.16.2007 at 03:16PM PST, ID: 18328603

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32