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.
Besides SQL Server login, discovering 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 collectionWhen registering (adding) an instance we are also asking for the sql server login (which we are not asking for during discovery).
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 will be using account details added via add instance wizardThe inclusion of cloud details when adding an instance is optional. However, the following metrics require cloud details for their collection.
DiskReadsPerSec |
DiskWritesPerSec |
AvgDiskQueueLength |
PercentDiskTime |
PercentIdleTime |
BytesSentPerSec |
BytesReceivedPerSec |
PacketsSentPerSec |
PacketsReceivedPerSec |
IDProcess |
PercentProcessorTime |
WorkingSet |
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
...