Get-MgmtSvcSqlHostingServerMetric

Reference

Module:: MgmtSvcSqlServer

Gets capacity metrics for a SQL Server hosting server.

Syntax

Get-MgmtSvcSqlHostingServerMetric
   [-HostingServerId] <String>
   [[-MetricName] <String[]>]
   [[-StartTime] <DateTime>]
   [[-EndTime] <DateTime>]
   [-AdminUri] <Uri>
   [-Token] <String>
   [-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
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	True
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
Position:	Named
Default value:	None
Required:	False
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
Position:	5
Default value:	None
Required:	False
Accept pipeline input:	True
Accept wildcard characters:	False

-HostingServerId

Specifies the ID of a SQL Server hosting server.

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

-MetricName

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

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

-StartTime

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

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

-Token

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

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

Inputs

None

Outputs

ResourceMetricSets

This cmdlet emits a ResourceMetricSets object.

Get-MgmtSvcSqlHostingServer