You can setup the Cloud account and proxy settings in the Back Up Databases wizard, Restore Databases Using the Restore Wizard, and Create Backup Templates wizard.
|
NOTE: LiteSpeed supports the following cloud storage: Amazon S3, Microsoft Azure Blob, Google Cloud Storage, S3 Compatible Storage. |
Cloud account |
Select the Cloud account from the drop-down list. |
|
Select the following items to add or edit the registered cloud account settings.
|
Proxy Settings |
Select the following items to edit the Cloud account proxy settings.
|
Striping is splitting one backup file into multiple files. The advantage of striping is that it provides higher upload performance when backing up to the Cloud and overcomes some Cloud limitations (e.g. maximum object size on Azure Block Blob storage is 4.75TB). Striping provides a significant performance benefit and time saving when backing up large database files. For example, striping three blocks of one database file up provides three times the upload bandwidth over backing up one large database file to a single cloud container.
LiteSpeed provides an automatic striping option for backing up databases. The option can be set to auto which enables LiteSpeed to manage the striped size. Alternately, you can set the striping size in GB. If the database size is larger than the specified stripe size then the file is striped when backed up.
Tip: Quest Software recommends using LiteSpeed defaults. |
To enable cloud automatic striping
Click to select Automatic Striping. The automatic striping options:
Note: Maximum size of block blob supported by Microsoft Azure is 4.77 TB. Stripes allow to override this limit.
Note: Maximum size of page blob supported by Microsoft Azure is 1000GB. Stripes allow to override this limit.
Note: Maximum size of object supported by Amazon S3 is 5000GB. LiteSpeed is limited by 2000GB. Stripes allow to override this limit.
S3 Compatible Storage: auto, 10, 25, 50, 100, 250, 500, 1000 and 1995 GB.
Google Cloud Storage: auto, 10, 25, 50, 100, 250, 500, 1000 and 1995 GB.
Note: Maximum size of object supported by Google Cloud Storage is 5 TB. LiteSpeed is limited by 2TB. Stripes allow to override this limit.
Higher compression levels result in smaller backup files, but they also may consume additional CPU. If the server does not have sufficient CPU, then the backup may take longer to complete. The Backup Analyzer evaluates different settings, such as compression level, striping, and backup destinations, to help you determine optimal backup settings.
NOTE: When running the Backup Analyzer, follow these guidelines for the best results:
Minimum: 1 GB sample size.
Recommendation: 10 GB sample size. The combination of compression levels, encryption options, and backup locations should be considered. For example, if you sample 4 GB of data with 10 different tests, LiteSpeed will take the same amount of time as it takes to back up 40 GB. On very large databases, you can speed up the analysis by reducing the number of backup combinations or by reducing the amount of sample data.
The Backup Analyzer wizard guides you through selecting the backup parameters to test. The wizard tests all of the different combinations of your selected parameters by backing up a portion of the database. It does not interfere with existing backup schedules or sets.
To run the Backup Analyzer wizard
Select the Backup Manager pane (CTRL+1).
Right-click the database and select Backup Analyzer Wizard.
Tips:
Review the following additional information about the advanced options:
Compression threads |
Determines the number of threads used for the backup. You will achieve the best results by specifying multiple threads, but the exact value depends on several factors including: processors available, affinity setting, compression level, encryption settings, IO device speed, and SQL Server responsiveness. The default is n-1 threads, where n is the number of processors. |
Max transfer size |
Enter the maximum backup file size in bytes. . The possible values are multiples of 65536 bytes (64 KB) ranging up to 4,194,304 bytes (4 MB). The default is 1048576. |
Buffer count |
Enter the number of SQL Server buffers available for a LiteSpeed operation. The default is set by SQL Server. |
CPU throttle |
Enter the maximum percentage of CPU that LiteSpeed can use for the process. The default is 100. |
Processor affinity |
Click to select which processors LiteSpeed can use. The default is 0, which allows LiteSpeed to use all available system processors. |
Processor priority |
Select the priority of the backup over other transactions or processes running on the same server. The default is Normal. |
Network resilience |
If LiteSpeed fails to write disk backups or reads from disk, it waits and retries the operation. You can enable and disable and control the number of times to retry and the amount of time to wait before retrying.
|
TIP: Before you start tuning the CPU Throttle or Affinity parameters to adjust backup performance, try limiting the number of threads. If you decide to use an affinity value other than default, it is recommended that you limit the threading as well. |
NOTE: LiteSpeed defaults typically result in the best performance. You should only modify advanced options after careful planning and testing. For more information, see Configure LiteSpeed Defaults.
NOTE: After the required number of bytes is received for analysis, the process is intentionally aborted. This generates the VDI error messages in the LiteSpeed log files and the SQL Server error log. Please ignore them.
You can schedule analyzing from within the Backup Analyzer Wizard. An SQL Server job with the name "LiteSpeed Analyzer SERVERNAME.DATABASENAME" is created. View the list of Backup Analyzer jobs directly from the Backup Analyzer tab by clicking "Show Analyzer Jobs." Right-click on the job. You can change schedule, start/stop, disable or even delete the job. To view the script, select the "View in Job Manager" option and open the job properties from the Job Manager module. You can then go to the job step details.
The Backup Analyzer tab consists of the toolbar, graph, and grid. The Backup Analyzer toolbar is used to select the following items:
The Backup Analyzer tab presents the test results in a graph and grid format:
Graph—Displays the backup duration and compression amount for each test in a bar graph so you can easily compare the results between size and duration. If you hover the mouse over the bar graph, test number, size, and duration are displayed. If you select a test in the grid, LiteSpeed indicates the corresponding test in the bar graph with a yellow border around it. You can view previous tests by changing the Existing test field.
Grid—Displays the details of each test in columnar format. LiteSpeed indicates its recommendation with the number indicated first in the Test Number column and a yellow box around the test bar graph. Review the following for additional information:
Tip: .Use the Grid horizontal scroll bar to view other table columns. |
Column | Description |
---|---|
Test Number |
The number assigned by the Backup Analyzer. |
Level |
The compression level that is used for a particular database backup test. |
Encryption |
Indicates enabled encryption for the database backup. |
Estimated Duration |
The approximate time allotted to run the database backup. |
Estimated Backup Size (MB) |
The approximate size of the backed up database. |
Database Size (MB) |
The amount of disk space the database occupies. |
Compression (MB) |
The amount of disk space you can save with this compression ratio. |
Compression (%) |
Data compression ratio. |
Read Speed (MB/Sec) | Maximum read speed. |
Throughput (MB/Sec) | Actual speed of processing data (compression and encryption). |
Backup Speed (MB/Sec) | Virtual write speed of the backup. Compare this value to Throughput and Read Speed to determine if you are experiencing a write-bound issue. |
Write Speed (MB/Sec) | Actual write speed. It shows how quickly the compressed data stream is written to the destination disk. |
Stripes | Number of stripes associated with the backup. |
Destination | Backup destination directory location. |
Threads | Number of threads associated with the backup. |
You can double-click a row for more information about the test.
Tip: For panes that have grids, you can sort, group, move, and remove the columns:
|
Higher compression levels result in smaller backup files, but they also may consume additional CPU. If the server does not have sufficient CPU, then the backup may take longer to complete. The Backup Analyzer evaluates different settings, such as compression level, striping, and backup destinations, to help you determine optimal backup settings.
NOTE: When running the Backup Analyzer, follow these guidelines for the best results:
Minimum: 1 GB sample size.
Recommendation: 10 GB sample size. The combination of compression levels, encryption options, and backup locations should be considered. For example, if you sample 4 GB of data with 10 different tests, LiteSpeed will take the same amount of time as it takes to back up 40 GB. On very large databases, you can speed up the analysis by reducing the number of backup combinations or by reducing the amount of sample data.
The Backup Analyzer wizard guides you through selecting the backup parameters to test. The wizard tests all of the different combinations of your selected parameters by backing up a portion of the database. It does not interfere with existing backup schedules or sets.
To run the Backup Analyzer wizard
Select the Backup Manager pane (CTRL+1).
Right-click the database and select Backup Analyzer Wizard.
Tips:
Review the following additional information about the advanced options:
Compression threads |
Determines the number of threads used for the backup. You will achieve the best results by specifying multiple threads, but the exact value depends on several factors including: processors available, affinity setting, compression level, encryption settings, IO device speed, and SQL Server responsiveness. The default is n-1 threads, where n is the number of processors. |
Max transfer size |
Enter the maximum backup file size in bytes. . The possible values are multiples of 65536 bytes (64 KB) ranging up to 4,194,304 bytes (4 MB). The default is 1048576. |
Buffer count |
Enter the number of SQL Server buffers available for a LiteSpeed operation. The default is set by SQL Server. |
CPU throttle |
Enter the maximum percentage of CPU that LiteSpeed can use for the process. The default is 100. |
Processor affinity |
Click to select which processors LiteSpeed can use. The default is 0, which allows LiteSpeed to use all available system processors. |
Processor priority |
Select the priority of the backup over other transactions or processes running on the same server. The default is Normal. |
Network resilience |
If LiteSpeed fails to write disk backups or reads from disk, it waits and retries the operation. You can enable and disable and control the number of times to retry and the amount of time to wait before retrying.
|
TIP: Before you start tuning the CPU Throttle or Affinity parameters to adjust backup performance, try limiting the number of threads. If you decide to use an affinity value other than default, it is recommended that you limit the threading as well. |
NOTE: LiteSpeed defaults typically result in the best performance. You should only modify advanced options after careful planning and testing. For more information, see Configure LiteSpeed Defaults.
NOTE: After the required number of bytes is received for analysis, the process is intentionally aborted. This generates the VDI error messages in the LiteSpeed log files and the SQL Server error log. Please ignore them.
You can schedule analyzing from within the Backup Analyzer Wizard. An SQL Server job with the name "LiteSpeed Analyzer SERVERNAME.DATABASENAME" is created. View the list of Backup Analyzer jobs directly from the Backup Analyzer tab by clicking "Show Analyzer Jobs." Right-click on the job. You can change schedule, start/stop, disable or even delete the job. To view the script, select the "View in Job Manager" option and open the job properties from the Job Manager module. You can then go to the job step details.
The Backup Analyzer tab consists of the toolbar, graph, and grid. The Backup Analyzer toolbar is used to select the following items:
The Backup Analyzer tab presents the test results in a graph and grid format:
Graph—Displays the backup duration and compression amount for each test in a bar graph so you can easily compare the results between size and duration. If you hover the mouse over the bar graph, test number, size, and duration are displayed. If you select a test in the grid, LiteSpeed indicates the corresponding test in the bar graph with a yellow border around it. You can view previous tests by changing the Existing test field.
Grid—Displays the details of each test in columnar format. LiteSpeed indicates its recommendation with the number indicated first in the Test Number column and a yellow box around the test bar graph. Review the following for additional information:
Tip: .Use the Grid horizontal scroll bar to view other table columns. |
Column | Description |
---|---|
Test Number |
The number assigned by the Backup Analyzer. |
Level |
The compression level that is used for a particular database backup test. |
Encryption |
Indicates enabled encryption for the database backup. |
Estimated Duration |
The approximate time allotted to run the database backup. |
Estimated Backup Size (MB) |
The approximate size of the backed up database. |
Database Size (MB) |
The amount of disk space the database occupies. |
Compression (MB) |
The amount of disk space you can save with this compression ratio. |
Compression (%) |
Data compression ratio. |
Read Speed (MB/Sec) | Maximum read speed. |
Throughput (MB/Sec) | Actual speed of processing data (compression and encryption). |
Backup Speed (MB/Sec) | Virtual write speed of the backup. Compare this value to Throughput and Read Speed to determine if you are experiencing a write-bound issue. |
Write Speed (MB/Sec) | Actual write speed. It shows how quickly the compressed data stream is written to the destination disk. |
Stripes | Number of stripes associated with the backup. |
Destination | Backup destination directory location. |
Threads | Number of threads associated with the backup. |
You can double-click a row for more information about the test.
Tip: For panes that have grids, you can sort, group, move, and remove the columns:
|
© ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center