Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

trainguy77

macrumors 68040
Original poster
Nov 13, 2003
3,567
1
I know this is mac basics but this is where most mods move PC questions.


I just installed windows server update services on a 2k3 system. I am using mssql as the database. trend micro office scan also uses mysql. When I try to approve update it sometimes just times out. When it does work it takes for ever. The CPU usage shoots through the roof. about %99 by the sqlservr process. It also take 190,000 k of RAM. Is this normal and how can I fix it? I think its a problem with the mysql but i don't know what. I have tried restarting. Its a 2.4 GHz system with 1gb of RAM. It only has 2 machines connected to the WSUS(more to come) Anyone any ideas would be great!

Does anyone know of a good PC forum that might be able to answer this question? I haved done some google search posted at one of them but most of them don't seem as active as macrumors. I would love to find a active PC Forum for the odd question. (don't worry i will still come here)
 

iMeowbot

macrumors G3
Aug 30, 2003
8,634
0
The MySQL forums would probably be a better bet. There were some known bugs in MySQL 4 that could cause trouble like that, have you updated to the latest?
 

trainguy77

macrumors 68040
Original poster
Nov 13, 2003
3,567
1
I am sorry I had the datebase wrong. Its MSSQL Dekstop Engine. Thanks for the help though!:D
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.