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 ...
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 ...
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 ...