Hello im new here and ive got some problems with my mssql database.

After 1h run time sqlservr.exe start to go crazy and jumps from 1-2% use to 80-90% use makeing my software lag and go very slow.

I run it on

- 2x Intel Xeon Dual Core 3.8 GHZ
- 1 x 73 GB 15k
- 2 x 142 GB 10k
- 4 x 2 GB RAM

Windows 2003 x64
mssql 2005 x64

Anyone got a clue what it might be?