This option helps you to change the storage location of SQL Workload Analysis database and message queue files for proper distribution. To change the location, follow these instructions below:
- Click Relocate Database/ Message Queue Files.
![SQL Workload Analysis 1.7.x > Storage > Relocate db.png](/download/attachments/12325978593/Relocate%20db.png?version=1&modificationDate=1501685986540&api=v2)
- Click BROWSE, to select a new location for the Data File Storage.
- Click BROWSE, to select a new location for the Message Queue Storage.
- Once you finish editing the new locations, click SAVE. If you do not want to save the changes, click CANCEL.
After saving your changes, a Warning message shows up asking if you want to proceed or cancel.
![SQL Workload Analysis 1.7.x > Storage > Warning.jpg](/download/attachments/12325978593/Warning.jpg?version=1&modificationDate=1498814519643&api=v2)
- Once SQLWA finished to move the files to the new locations, a message shows up confirming the results of the operation. Click OK.
![SQL Workload Analysis 1.7.x > Storage > image2017-9-27_12-6-24.png](/download/attachments/12325978593/image2017-9-27_12-6-24.png?version=1&modificationDate=1506510384370&api=v2)
SQL Workload Analysis add-on provides a granular breakdown of wait states with easy drill-down to isolate problems quickly. | | | | | | | ![](/plugins/servlet/confluence/placeholder/macro?definition=e25ld3RhYmZvb3RlcjphbGlhcz1MZWdhbHx1cmw9aHR0cHM6Ly93d3cuaWRlcmEuY29tL2xlZ2FsL3Rlcm1zb2Z1c2V9&locale=en_US&version=2)
|