Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...