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...
If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.