Kendall Posted June 30, 2009 Posted June 30, 2009 Hey all I got a very odd problem with my database server, mssql keep peaking at a load of 100% every 2-4min making major item lags on server. Ive never ever hade any problems like this and ive tryed everything it seems now and still problem are there. I use MSSQL 2005 Anyone that got a clue what it can be?
0 Franken Posted August 7, 2009 Posted August 7, 2009 Maybe hardware problem? How many RAM do you have?
0 robertocarlos1 Posted October 12, 2010 Posted October 12, 2010 1- add more virtual memory in boot.ini, 2- and put more memory ram in you machine type : if > 5 GB ... 3- lets 2 hds in raid sata II . 4- delete npcs event, merchants, seven signs mobs extras for tests. leaves very slight improvement. enjoy !!!! so rolls.
0 Anarchy Posted October 12, 2010 Posted October 12, 2010 /sigh 1. Topic is over a year old 2. It's transaction log reallocation and none of your 4 suggestions.
Question
Kendall
Hey all
I got a very odd problem with my database server, mssql keep peaking at a load of 100% every 2-4min making major item lags on server. Ive never ever hade any problems like this and ive tryed everything it seems now and still problem are there.
I use MSSQL 2005
Anyone that got a clue what it can be?
3 answers to this question
Recommended Posts