Page History
SQL Inventory Manager retrieves the majority of the metrics using SQL Scripts but the performance metrics need to be retrieved using API.
For Azure: "Specify the account to be used to connect to the Azure VM or Database. Azure account information is needed to collect performance metrics. Please note that you may see charges from Microsoft for API requests. Click here [insert url to wiki page] for more information."
For Amazon: "Specify the account to be used to connect to the Amazon EC2 or RDS instance. Amazon account information is needed to collect performance metrics. Please note that you may see charges from Amazon for Cloudwatch API requests. Click here [insert url to wiki page] for more information."
To access the cloud instances discovery options click Cloud on the left pane of the Discovery Center Options view.
Discovering and adding instances require the same set of credentials. Instance registration also requires SQL Server login
The inclusion of cloud details when adding an instance is optional. However, the following metrics require cloud details for their collection.
SQL Inventory Manager retrieves the majority of the metrics using SQL Scripts but retrieving performance metrics require the use of API calls.
There are two scenarios when discovering instances:There are 2 scenarios
Scenario 1: Instance is discovered using cloud account. In this case, the account is already associated with this instance so API calls will be using this account
Scenario 2: Instance is not discovered, but added directly from add instance screen in this case, api API calls will be using account details added via add instance wizard
...
When adding an instance, the cloud details are optional. User can choose not to add these. If they do not specify the cloud account details, the following metrics cannot be retrieved
starting from line number 56 to 67 in this doc:
https://docs.google.com/spreadsheets/d/1BmIdiQ0X9ebjLIQN7SLMJxbqn_QNeKy4szHl71oDrcc/edit?ts=5bb269f8#gid=0
Note |
---|
Sql server login is mandatory when registering an instance |
Discovering Amazon Instances
The Amazon tab on the Cloud Discovery Settings section allows you to set and edit Amazon accounts for discovering instances.
Info | ||
---|---|---|
| ||
Make sure you perform these steps before adding an Amazon account on SIM.
|
Adding an Amazon account
For Amazon: "Specify the account to be used to connect to the Amazon EC2 or RDS instance. Amazon account information is needed to collect performance metrics. Please note that you may see charges from Amazon for Cloudwatch API requests. Click here [insert url to wiki page] for more information."
Click Add Amazon Account and enter the following information on the Amazon Account dialog.
AWS Account Name: Name for referencing the AWS account.
AWS Access Key: Access ID.
AWS Secret Key: Secret access key information.
AWS Region Endpoint: Select your Amazon region.
Editing an account
To edit an Amazon account click on the gear icon next to the account name you want to edit and select Edit. Once you modify your information on the Add/Edit dialog click Save to save your changes.
Removing an account
To remove an Amazon account click on the gear icon next to the account name you want to remove and select Remove.
Note: All the instances discovered before removing an account remain on the Discovered View.
Discovering Azure Instances
The Azure tab on the Cloud Discovery Settings section allows you to set and edit Amazon accounts for discovering instances.
Adding an Amazon account
Click Add Azure Account and enter the following information on the Amazon Account dialog.
Azure Account Name: Name for referencing the Azure account.
Azure Tenant ID: The ID of the AAD directory in which the application resides.
Azure Client ID: The Application ID name.
Azure Client Secret Key: Application ID key.
Azure Subscription ID: Your subscription ID.
Editing an account
To edit an Azure account click on the gear icon next to the account name you want to edit and select Edit. Once you modify your information on the Add/Edit dialog click Save to save your changes.
Removing an account
To remove an Azure account click on the gear icon next to the account name you want to remove and select Remove.
For more information on how to discover Amazon Instances refer to AWS Setup.
For more information on how to discover Azure Instances refer to Azure Setup.