Skip to content

stretch-database-databases-and-tables-stretch-database-advisor.md

Latest commit

 

History

History
70 lines (49 loc) · 3.73 KB

stretch-database-databases-and-tables-stretch-database-advisor.md

File metadata and controls

70 lines (49 loc) · 3.73 KB
title Stretch Database databases and tables - Stretch Database Advisor | Microsoft Docs
ms.custom
SQL2016_New_Updated
ms.date 06/14/2016
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
dbe-stretch
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
Stretch Database, identifying databases
Stretch Database, identifying tables
identifying databases for Stretch Database
identifying tables for Stretch Database
ms.assetid 81bd93d8-eef8-4572-88d7-5c37ab5ac2bf
caps.latest.revision 29
author douglaslMS
ms.author douglasl
manager craigg

Stretch Database databases and tables - Stretch Database Advisor

[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx_md]

To identify databases and tables that are candidates for Stretch Database, download SQL Server 2016 Upgrade Advisor and run the Stretch Database Advisor. Stretch Database Advisor also identifies blocking issues.

Download and install Upgrade Advisor

Download and install Upgrade Advisor from here. This tool is not included on the [!INCLUDEssSQL15] installation media.

Run the Stretch Database Advisor

  1. Run Upgrade Advisor.

  2. Select Scenarios, and then select RUN STRETCH DATABASE ADVISOR.

  3. On the Run Stretch Database Advisor blade, click SELECT DATABASES TO ANALYZE.

  4. On the Select databases blade, enter or select the server name and the authentication info. Click Connect.

  5. A list of databases on the selected server appears. Select the databases that you want to analyze. Click Select.

  6. On the Run Stretch Database Advisor blade, click Run. The analysis runs.

Review the results

  1. When the analysis is finished, on the Analyzed databases blade, select one of the databases that you analyzed to display the Analysis results blade.

    The Analysis results blade lists recommended tables in the selected database that match the default recommendation criteria.

  2. In the list of tables on the Analysis results blade, select one of the recommended tables to display the Table results blade.

    If there are blocking issues, the Table results blade lists the blocking issues for the selected table. For information about blocking issues detected by Stretch Database Advisor, see Limitations for Stretch Database.

  3. In the list of blocking issues on the Table results blade, select one of the issues to display more info about the selected issue and proposes mitigation steps. Implement the suggested mitigation steps if you want to configure the selected table for Stretch Database.

Next step

Enable Stretch Database.

See Also

Limitations for Stretch Database
Enable Stretch Database for a database
Enable Stretch Database for a table