I have just found the exellent Activity Monitor tool in 2008. Whilst going through the different views I noticed that in my resource waits, the entry Logging is extremely high.
Over 1000ms/sec which I reckon is pretty nasty.
I have been trying to find out what Logging is actually showing. Can anyone give me any pointers to where I should be looking. Is this transaction logging or harddrive logging or what. What performance counters should I be looking at.
In the resource monitor I can see my HD is about 10% normal use but the Most active used is always way higher.
I am at a loss.
Any suggestions would be gratefully received.