A neat test for read speed backup throughput is to use the Backup to NUL .
NUL is a special “file”. It's as a nul device , anything “written” to it is discarded.Don’t confuse with the SQL reserved word NULL.
Before you run this statement , note that even as the file is not going anywhere , SQL Server still considers it to be valid BACKUP – therefore any subsequent LOG backups would be invalid , until you commit another FULL BACKUP.
Use the COPY_ONLY option to avoid this problem
1: backup database MY_DB to disk = 'NUL:' with stats = 10 Sample output: Processed 1706648 pages for database 'MY_DB', file 'MY_DB' on file 1. 100 percent processed. Processed 38 pages for database 'MY_DB', file 'MY_DB_log' on file 1. BACKUP DATABASE successfully processed 1706686 pages in 28.221 seconds (495.417 MB/sec).
Accompany the statement with : Logical Disk Read Bytes/sec on relevant disk to obtain read throughput