I have had some serious SQL server performance problems in the last few weeks. Microsoft RMS is working very slow at times and the problem is at the sql server. I ran the wait stats code from this page.
I first cleared the stats and then checked in 10 min. The numbers in the following picture look very high to me. This is after having reset the counters for about 10 minutes. Is this normal? What should I look at doing to bring these numbers down?
After about another 10 minutes the wait stats were like the following.
I've noticed the file system is fragmented pretty bad. I'll try to defragment the file system once I can shut down the sql server because the defragmenter cannot defragment the database files while the sql server is running. But I don't know if fragmentation can reduce the performance so much..??