3
votes
0answers
73 views

What utilities can I use to simulate I/O load for a DB restore and DBCC check?

I'm trying to figure out the peak load I can sustain on new hardware I procured for validating backups and performing DBCC checks. I've been using Crystal Diskmark to get throughput stats which helped ...
1
vote
1answer
139 views

Hard Drive Configuration for my setup

I have a fairly large transactional database (100GB) with a lot of users. The database access is solely via stored procs that make heavy use of temp tables, table variables, cursors and other fun ...
0
votes
0answers
30 views

Getting info on hard disk [closed]

Apologies if this question is too simple for gurus. For a windows box with a given hard drive, I wish to determine: The max disk i/o, the hard disk is capable of The number of platters in the hard ...