| Author |
 Topic  |
|
|
suona
Junior Member
Taiwan
121 Posts |
 Posted - 09 March 2009 : 10:32:31
|
My server runs w2k server + SQL 7.0, physical memory 768MB,SQL physical memory 250MB
This server is my web server, email server ,too. There's several ASP programs running, including two snitz forums. Concurrent Internet connect users 20-30 MAX.
THis system works well before, but not well these days. Since last weekm ,the server will periodically accessing HDD nonstop for 5-15 minutes, makes the whole system LAG! somtime even the WEB,APS services are stopped during this HDD accssing period.
After the HDD stop running, most time all internet services will recover, but sometimes they stop forever, I've to restart the server.
When HDD running , I open taskmanager(also LAG!!!), free physical memory more than 150MB, don't like swapping. CPU Usage, sqlserver.exe is the highest.
Since I'm an amateur , I can only guess there's something happend related with SQL server. How can I go further to find out where the exact problem is?
Thanks a lot! |
I'm a amateur WWW site builder.
And Sorry for my poor english .....
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 09 March 2009 : 10:50:15
|
You could probably try the SQL Server activity monitor to see what is going on.
Anyway, one thing that you should probably do is increase the memory of that server. Looks like SQL Server is having to resort to disk a lot, so adding more RAM should would help with it. You could also probably do other stuff, like rebuilding database indexes, but maybe after having a look at the activity monitor to try to figure out what is going on. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
suona
Junior Member
Taiwan
121 Posts |
Posted - 11 March 2009 : 02:09:16
|
I cannot really understand the items of "Performance Monitor"ˇAand their normal value should be......
My server's motherboard was very old & basic, supports only 768MB RAM. I think maybe change a new motherboard and add more RAM will solve this problem ?
|
I'm a amateur WWW site builder.
And Sorry for my poor english .....
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 11 March 2009 : 06:15:08
|
Well surely different hardware can make a difference. Depending on the actual problem, it may solve it or just postpone a need for a solution to the specific problem, I really don't know and would be ridiculous to pretend otherwise.
You can have a look at wait times, in activity monitor, it may give you an idea of what's taking more time to complete. Probably you will have some stuff waiting for I/O, so that can give you a hint about what's going on.
SQL Server can really jump in performance with more memory available. I can't say if it would solve the problem, though, and I would try to find out the issue before buying a new motherboard. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
|
| |
Topic |
|
|
|
Topic Locked
