MSSQL Problem!!!!

[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?

[Franken]

Maybe hardware problem? How many RAM do you have?

[robertocarlos1]

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.

[Anarchy]

/sigh

 

1. Topic is over a year old

2. It's transaction log reallocation and none of your 4 suggestions.