I have sql server 2008 R2 Express SP2 instance running on a windows xp sp3 machine.
There is only one front-end application making use of this sql instance.
I noticed today that my front end application slowed down to less than 1% of its expected performance. The xp machine has 4GB memory and is not maxed out. The CPU averages around 12-15% utilization.
I found though that the %DiskTime on perfmon is flatlining at 100% and has been at 100% for hours. On the sql activity monitor, I can see that my sql instance is utilizing disk i/o at around 25-32mb/sec. Thats probably why my disk is at 100%.
My database is set to simple recovery mode. The front end app is not even writing large numbers to the database - roughly 40,000 records over the last 12 hours.
Please help me find the cause of the abnormal disk i/o.
Thanks a lot!