I have an SQL Server 2000 running on Windows Server 2003 R2 Standard SP2 and I've been getting complaints that our point of sale is crawling on a daily basis. I pretty much concluded that it's due to our high Avg. Disks Queue Length. Whenever we have slowness complaints I do see the our Avg. Disks Queue Length is through the roof. Any idea how I can see who's making request to the SQL server causing the Avg. Disks Queue Length to spike OR any recommendations on how to better analyze the situation so I can see where I need more resources? Are there better tools I should be using other than the Performance Monitor?
Hope these links will helps...
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.