When troubleshooting performance issues on a Microsoft SQL Server application hosted on a VPLEX virtual volume, adjusting the data mobility job transfer rate can have a significant impact on the application’s performance. A higher transfer rate can help improve performance by allowing data to be moved more quickly, reducing the impact on the application’s I/O operations.

Assessing Current Performance: The current transfer rate of 32 MB may be insufficient for the workload of the SQL Server application, leading to performance issues1.

Recommended Transfer Rate: Increasing the transfer rate to 120 MB can help alleviate these performance issues by accelerating the data mobility process, thus minimizing the time during which the SQL Server application’s performance is impacted1.

Implementing the Change: To change the transfer rate, the administrator would use the VPLEX CLI to adjust the settings for the data mobility jB. This involves modifying the transfer rate parameter to the new value of 120 MB1.

Monitoring the Impact: After making the change, it’s important to monitor the SQL Server application’s performance to ensure that the new transfer rate is having the desired effect and not causing any additional issues1.

Best Practices: It is recommended to follow best practices for data mobility and performance tuning as outlined in the Dell VPLEX documentation, which includes considering the impact of data mobility jobs on application performance1.

In summary, changing the data mobility job transfer rate to 120 MB is recommended to help improve the performance of the Microsoft SQL Server application hosted on a VPLEX virtual volume.

=========================