Windows Forum

Ask something
Discussion Locked

CPU Utilisation

0 helpful
2 replies

by bubloo

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Dear All

we have zenith entry level server(PIII-650 Mhz,10 GB SCSI HDD, INTEL 440BX mbd, 256 MB RAM), We have IIS & sql server running in our server and we have around 15 users, throught the day they will feed the data (like customer name,phone no, address etc) to sql.

Now my problem is our server is dam slow, and our CPU utilisation is always 100%. Our page file size is 512MB. I am really surprised y CPU utilisation is always 100%, becoz i have stopped unnecessary services. Only 2 major application is running, (IIS and SQL). We have around 706 mb free disk space in our boot partision.

Kindly help us to speed up the server performance.

Thanks in advance

Sakthi

2 replies

by mgonzales

First off add more ram. More ram the system has to use the faster it will work. Which process is taking up the resources? This also could be related to a poorly written stored procedure or query/report that runs.

by shawn

Definetley add more RAM, as much as you can afford to "cram" into the box.

Next, look at setting up a scheduled task that stops and starts the SQL services automatically during off times (when your users are there using SQL). I find that works best for my SQL Server, and it's only required during the day, so I stop and restart the services overnight.

You can also look at some performance tweaks for SQL Server. Google "SQL Server poerformance tweaks" and yuo should get some good ideas about how to tune the server.

Hope this helps.

Shawn

This discussion is closed to new replies.