Reputation
Top tag
Next privilege 50 Rep.
Comment everywhere
Badges
5
Newest
 Supporter
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 1 vote cast
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.