LiteSpeed's Backup Analyzer can do more than just find the right backup compression and encryption settings. It can also help pinpoint your SQL Server's backup bottleneck, showing why you can't back up your databases faster.
In my screenshot above, my lab server’s data drives are connected via iSCSI. Notice that my read speeds are consistent across all of my tests. That’s because I just flat out can’t read the data any faster than I’m reading it. The only solution to make this server faster is to upgrade the connection between the data file drives and the server itself.
However, since I know I just can’t read that fast, that means I can use as much encryption and compression as I want without affecting performance. In this situation, I might retest with stronger encryption methods and higher compression levels. Even though I’m read-constrained, that doesn’t mean I can’t get benefits from using LiteSpeed’s compression.
See:
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center