Aracılığıyla paylaş

Get-AzDataMigrationPerformanceDataCollection

  • Başvuru
Modül:
Az.DataMigration

Belirli SQL Server örnekleri için performans verilerini toplama

Syntax

Get-AzDataMigrationPerformanceDataCollection
   -SqlConnectionStrings <String[]>
   [-OutputFolder <String>]
   [-PerfQueryInterval <String>]
   [-StaticQueryInterval <String>]
   [-NumberOfIterations <String>]
   [-Time <Int64>]
   [-PassThru]
   [<CommonParameters>]
Get-AzDataMigrationPerformanceDataCollection
   [-Time <Int64>]
   -ConfigFilePath <String>
   [-PassThru]
   [<CommonParameters>]

Description

Belirli SQL Server örnekleri için performans verilerini toplama

Örnekler

Örnek 1: bağlantı dizesi kullanarak verilen SQL Server'da Performans Veri Toplamayı çalıştırma

Get-AzDataMigrationPerformanceDataCollection -SqlConnectionStrings "Data Source=AALAB03-2K8.REDMOND.CORP.MICROSOFT.COM;Initial Catalog=master;Integrated Security=False;User Id=dummyUserId;Password=dummyPassword" -NumberOfIterations 2

Connecting to the SQL server(s)...
Starting data collection...
Press the Enter key to stop the data collection at any time...

Security Warning: The negotiated TLS 1.0 is an insecure protocol and is supported for backward compatibility only. The recommended protocol version is TLS 1.2 and later.
Security Warning: The negotiated TLS 1.0 is an insecure protocol and is supported for backward compatibility only. The recommended protocol version is TLS 1.2 and later.
Security Warning: The negotiated TLS 1.0 is an insecure protocol and is supported for backward compatibility only. The recommended protocol version is TLS 1.2 and later.
UTC 2022-02-03 07:04:50, Server AALAB03-2K8:
        Performance data query iteration: 1 of 2, collected 349 data points.
UTC 2022-02-03 07:04:52, Server AALAB03-2K8:
        Collected static configuration data, and saved to C:\Users\vmanhas\AppData\Local\Microsoft\SqlAssessment.
Security Warning: The negotiated TLS 1.0 is an insecure protocol and is supported for backward compatibility only. The recommended protocol version is TLS 1.2 and later.
UTC 2022-02-03 07:05:44, Server AALAB03-2K8:
        Performance data query iteration: 2 of 2, collected 347 data points.
UTC 2022-02-03 07:07:13, Server AALAB03-2K8:
        Aggregated 696 raw data points to 263 performance counters, and saved to C:\Users\vmanhas\AppData\Local\Microsoft\SqlAssessment.
UTC 2022-02-03 07:07:16, Server AALAB03-2K8:
        Performance data query iteration: 1 of 2, collected 349 data points.

Event and Error Logs Folder Path: C:\Users\vmanhas\AppData\Local\Microsoft\SqlAssessment\Logs

Bu komut, bağlantı dizesi kullanarak verilen SQL Server'da Performans Veri Toplama'ya çalışır.

Örnek 2: Değerlendirme yapılandırma dosyasını kullanarak verilen SQL Server'da Performans Veri Toplamayı çalıştırma

Get-AzDataMigrationPerformanceDataCollection -ConfigFilePath "C:\Users\user\document\config.json"

Connecting to the SQL server(s)...
Starting data collection...
Press the Enter key to stop the data collection at any time...

Security Warning: The negotiated TLS 1.0 is an insecure protocol and is supported for backward compatibility only. The recommended protocol version is TLS 1.2 and later.
Security Warning: The negotiated TLS 1.0 is an insecure protocol and is supported for backward compatibility only. The recommended protocol version is TLS 1.2 and later.
Security Warning: The negotiated TLS 1.0 is an insecure protocol and is supported for backward compatibility only. The recommended protocol version is TLS 1.2 and later.
UTC 2022-02-03 07:04:50, Server AALAB03-2K8:
        Performance data query iteration: 1 of 2, collected 349 data points.
UTC 2022-02-03 07:04:52, Server AALAB03-2K8:
        Collected static configuration data, and saved to C:\Users\vmanhas\AppData\Local\Microsoft\SqlAssessment.
Security Warning: The negotiated TLS 1.0 is an insecure protocol and is supported for backward compatibility only. The recommended protocol version is TLS 1.2 and later.
UTC 2022-02-03 07:05:44, Server AALAB03-2K8:
        Performance data query iteration: 2 of 2, collected 347 data points.
UTC 2022-02-03 07:07:13, Server AALAB03-2K8:
        Aggregated 696 raw data points to 263 performance counters, and saved to C:\Users\vmanhas\AppData\Local\Microsoft\SqlAssessment.
UTC 2022-02-03 07:07:16, Server AALAB03-2K8:
        Performance data query iteration: 1 of 2, collected 349 data points.

Event and Error Logs Folder Path: C:\Users\vmanhas\AppData\Local\Microsoft\SqlAssessment\Logs

Bu komut, yapılandırma dosyasını kullanarak verilen SQL Server'da Performans Verileri Toplama'yi çalıştırır.

Örnek 3: Belirtilen bir süreden sonra durdurulan belirli bir SQL Server'da Performans Veri Toplamayı çalıştırma

Get-AzDataMigrationPerformanceDataCollection -ConfigFilePath "C:\Users\user\document\config.json" -Time 120

Connecting to the SQL server(s)...
Starting data collection...
Press the Enter key to stop the data collection at any time...

Security Warning: The negotiated TLS 1.0 is an insecure protocol and is supported for backward compatibility only. The recommended protocol version is TLS 1.2 and later.
Security Warning: The negotiated TLS 1.0 is an insecure protocol and is supported for backward compatibility only. The recommended protocol version is TLS 1.2 and later.
Security Warning: The negotiated TLS 1.0 is an insecure protocol and is supported for backward compatibility only. The recommended protocol version is TLS 1.2 and later.
UTC 2022-02-03 07:04:50, Server AALAB03-2K8:
        Performance data query iteration: 1 of 2, collected 349 data points.
UTC 2022-02-03 07:04:52, Server AALAB03-2K8:
        Collected static configuration data, and saved to C:\Users\vmanhas\AppData\Local\Microsoft\SqlAssessment.
Security Warning: The negotiated TLS 1.0 is an insecure protocol and is supported for backward compatibility only. The recommended protocol version is TLS 1.2 and later.
UTC 2022-02-03 07:05:44, Server AALAB03-2K8:
        Performance data query iteration: 2 of 2, collected 347 data points.
UTC 2022-02-03 07:07:13, Server AALAB03-2K8:
        Aggregated 696 raw data points to 263 performance counters, and saved to C:\Users\vmanhas\AppData\Local\Microsoft\SqlAssessment.
UTC 2022-02-03 07:07:16, Server AALAB03-2K8:
        Performance data query iteration: 1 of 2, collected 349 data points.

Event and Error Logs Folder Path: C:\Users\vmanhas\AppData\Local\Microsoft\SqlAssessment\Logs

Bu komut, belirtilen bir süreden sonra durdurulan belirli bir SQL Server'da Performans Veri Toplamayı çalıştırır.

Parametreler

-ConfigFilePath

ConfigFile yolu

Tür:String
Position:Named
varsayılan değer:None
Gerekli:True
Accept pipeline input:False
Accept wildcard characters:False

-NumberOfIterations

Dosyada kalıcı hale getirilmeden önce gerçekleştirilecek performans verileri toplama yinelemelerinin sayısı. Örneğin, varsayılan değerlerle performans verileri 30 saniyede bir * 20 yineleme = 10 dakikada bir kalıcı hale getirilir. (Varsayılan: 20, En Az: 2)

Tür:String
Position:Named
varsayılan değer:None
Gerekli:False
Accept pipeline input:False
Accept wildcard characters:False

-OutputFolder

Hangi veri ve sonuç raporlarının yazılacağı/okunacağı klasör.

Tür:String
Position:Named
varsayılan değer:None
Gerekli:False
Accept pipeline input:False
Accept wildcard characters:False

-PassThru

Tür:SwitchParameter
Position:Named
varsayılan değer:None
Gerekli:False
Accept pipeline input:False
Accept wildcard characters:False

-PerfQueryInterval

Performans verilerinin saniye cinsinden sorgulandığı aralık. (Varsayılan: 30)

Tür:String
Position:Named
varsayılan değer:None
Gerekli:False
Accept pipeline input:False
Accept wildcard characters:False

-SqlConnectionStrings

Sql Server Bağlan ion Dizeleri

Tür:String[]
Position:Named
varsayılan değer:None
Gerekli:True
Accept pipeline input:False
Accept wildcard characters:False

-StaticQueryInterval

Statik yapılandırma verilerini sorgulama ve kalıcı hale getirmek için saniye cinsinden aralık. (Varsayılan: 3600)

Tür:String
Position:Named
varsayılan değer:None
Gerekli:False
Accept pipeline input:False
Accept wildcard characters:False

-Time

Performans verilerini toplamak istediğiniz saniye cinsinden süre

Tür:Int64
Position:Named
varsayılan değer:None
Gerekli:False
Accept pipeline input:False
Accept wildcard characters:False

Çıkışlar

Boolean