C# Class Microsoft.Azure.Commands.Sql.Service.AzureSqlDatabaseIndexRecommendationCommunicator

This class is responsible for all the REST communication with the server upgrade REST endpoints
Show file Open project: Azure/azure-powershell Class Usage Examples

Private Properties

Property Type Description
GetCurrentSqlClient Microsoft.Azure.Management.Sql.SqlManagementClient

Public Methods

Method Description
AzureSqlDatabaseIndexRecommendationCommunicator ( AzureContext context ) : Microsoft.Azure.Commands.Common.Authentication

Creates a communicator for Azure Sql Databases
ListRecommendedIndexes ( string resourceGroupName, string serverName, string databaseName, string clientRequestId ) : List

List all recommended indexes. If database name is null get recommendations for all databases on server.
UpdateRecommendedIndexState ( string resourceGroupName, string serverName, string databaseName, string schema, string table, string recommendedIndexName, string state, string clientRequestId ) : void

Update recommended index state

Private Methods

Method Description
GetCurrentSqlClient ( String clientRequestId ) : Microsoft.Azure.Management.Sql.SqlManagementClient

Retrieve the SQL Management client for the currently selected subscription, adding the session and request id tracing headers for the current cmdlet invocation.

Method Details

AzureSqlDatabaseIndexRecommendationCommunicator() public method

Creates a communicator for Azure Sql Databases
public AzureSqlDatabaseIndexRecommendationCommunicator ( AzureContext context ) : Microsoft.Azure.Commands.Common.Authentication
context Microsoft.Azure.Commands.Common.Authentication.Models.AzureContext
return Microsoft.Azure.Commands.Common.Authentication

ListRecommendedIndexes() public method

List all recommended indexes. If database name is null get recommendations for all databases on server.
public ListRecommendedIndexes ( string resourceGroupName, string serverName, string databaseName, string clientRequestId ) : List
resourceGroupName string Resource group
serverName string Server name
databaseName string Database name
clientRequestId string Request id
return List

UpdateRecommendedIndexState() public method

Update recommended index state
public UpdateRecommendedIndexState ( string resourceGroupName, string serverName, string databaseName, string schema, string table, string recommendedIndexName, string state, string clientRequestId ) : void
resourceGroupName string Resource group
serverName string Server name
databaseName string Database name
schema string Schema name
table string Table name
recommendedIndexName string Recommended index
state string State
clientRequestId string Request id
return void