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