Get-MgmtSvcSqlHostingServerMetric
Get-MgmtSvcSqlHostingServerMetric
Gets capacity metrics for a SQL Server hosting server.
Syntax
Parameter Set: Default
Get-MgmtSvcSqlHostingServerMetric [-AdminUri] <Uri> [-Token] <String> [-HostingServerId] <String> [[-MetricName] <String[]> ] [[-StartTime] <DateTime> ] [[-EndTime] <DateTime> ] [-DisableCertificateValidation] [ <CommonParameters>]
Detailed Description
The Get-MgmtSvcSqlHostingServerMetric cmdlet gets metrics for a SQL Server hosting server. By default, all metrics for a specified hosting server are returned. To get a specific metric, use the MetricName parameter. You can also narrow your results by using the StartTime and EndTime parameters to specify a date range.
Parameters
-AdminUri<Uri>
Specifies the URI of the Windows Azure Pack administrator API. Use the following format: https://<computer>:<port>, where <computer> is the computer on which the administrator API is installed.
Aliases |
none |
Required? |
true |
Position? |
1 |
Default Value |
none |
Accept Pipeline Input? |
True (ByPropertyName) |
Accept Wildcard Characters? |
false |
-DisableCertificateValidation
Disables certificate validation for the Windows Azure Pack installation.
If you specify this parameter, you can use self-signed certificates.
Aliases |
none |
Required? |
false |
Position? |
named |
Default Value |
none |
Accept Pipeline Input? |
false |
Accept Wildcard Characters? |
false |
-EndTime<DateTime>
Specifies the end time of the date range as a DateTime object. To create a DateTime object, use the Get-Date cmdlet.
Aliases |
none |
Required? |
false |
Position? |
6 |
Default Value |
none |
Accept Pipeline Input? |
True (ByPropertyName) |
Accept Wildcard Characters? |
false |
-HostingServerId<String>
Specifies the ID of a SQL Server hosting server.
Aliases |
none |
Required? |
true |
Position? |
3 |
Default Value |
none |
Accept Pipeline Input? |
True (ByPropertyName) |
Accept Wildcard Characters? |
false |
-MetricName<String[]>
Specifies an array of metric names. You can get the following metrics: DatabaseCount, TotalAllottedSpace.
Aliases |
none |
Required? |
false |
Position? |
4 |
Default Value |
none |
Accept Pipeline Input? |
True (ByPropertyName) |
Accept Wildcard Characters? |
false |
-StartTime<DateTime>
Specifies the start time of the date range as a DateTime object.
Aliases |
none |
Required? |
false |
Position? |
5 |
Default Value |
none |
Accept Pipeline Input? |
True (ByPropertyName) |
Accept Wildcard Characters? |
false |
-Token<String>
Specifies an identity token. To create a token, use the Get-MgmtSvcToken cmdlet.
Aliases |
none |
Required? |
true |
Position? |
2 |
Default Value |
none |
Accept Pipeline Input? |
True (ByPropertyName) |
Accept Wildcard Characters? |
false |
<CommonParameters>
This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters (https://go.microsoft.com/fwlink/p/?LinkID=113216).
Inputs
The input type is the type of the objects that you can pipe to the cmdlet.
- None
Outputs
The output type is the type of the objects that the cmdlet emits.
ResourceMetricSets
This cmdlet emits a ResourceMetricSets object.
Examples
Example 1: Get the metrics for DatabaseCount
NOTE: This example assumes that you have created a token by using Get-MgmtSvcToken and have stored it in a variable named $Token.
This command gets the DatabaseCount metrics for the hosting server with the ID of u37k25.
PS C:\> Get-MgmtSvcSqlHostingServerMetric -AdminUri "https://Computer01:30004" -Token $Token -HostingServerId "u37k25" -MetricName DatabaseCount