Get-MgmtSvcSqlHostingServerMetric

Gets capacity metrics for a SQL Server hosting server.

Syntax

Get-MgmtSvcSqlHostingServerMetric [-AdminUri] <Uri> [-Token] <String> [-HostingServerId] <String>
 [[-MetricName] <String[]>] [[-StartTime] <DateTime>] [[-EndTime] <DateTime>] [-DisableCertificateValidation]
 [<CommonParameters>]

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.

Examples

Example 1: Get the metrics for DatabaseCount

PS C:\> Get-MgmtSvcSqlHostingServerMetric -AdminUri "https://Computer01:30004" -Token $Token -HostingServerId "u37k25" -MetricName 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.

Parameters

-AdminUri

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.

Type:Uri
Required:True
Position:0
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.

Type:SwitchParameter
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

-EndTime

Specifies the end time of the date range as a DateTime object.
To create a DateTime object, use the Get-Date cmdlet.

Type:DateTime
Required:False
Position:5
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-HostingServerId

Specifies the ID of a SQL Server hosting server.

Type:String
Required:True
Position:2
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-MetricName

Specifies an array of metric names.
You can get the following metrics: DatabaseCount, TotalAllottedSpace.

Type:String[]
Required:False
Position:3
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-StartTime

Specifies the start time of the date range as a DateTime object.

Type:DateTime
Required:False
Position:4
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

-Token

Specifies an identity token.
To create a token, use the Get-MgmtSvcToken cmdlet.

Type:String
Required:True
Position:1
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

Inputs

None

Outputs

ResourceMetricSets

This cmdlet emits a **ResourceMetricSets** object.