20 reputation
5
bio website chaosloop.net
location Pittsburgh, PA
age 31
visits member for 4 years, 1 month
seen Sep 17 '12 at 16:47
hi.

Oct
19
comment Best way to improve disk performance (SQL Server 2000)
Thanks for the answers; I'd like to upvote/accept multiple as many gave me good things to look at. I think I'm going to wait until we move to newer sql server (Should be fairly soon) and do a number of the improvements mentioned below.
Oct
18
comment Best way to improve disk performance (SQL Server 2000)
Currently; we sit ~20% memory usage at any given moment; is there a benefit from growing this greaty? The barometer I am using to determine if I am disk bound is the average QUEUE length; which spikes above 100 when some of my high load operations kick off...
Oct
18
comment Best way to improve disk performance (SQL Server 2000)
64bit Enterprise I believe.