Perintah workload_group .alter-merge
Mengubah grup beban kerja.
Izin
Anda harus memiliki izin Cluster AllDatabasesAdmin untuk menjalankan perintah ini.
Sintaks
.alter-merge
workload_group
WorkloadGroupName SerializedPolicyObject
Pelajari selengkapnya tentang konvensi sintaksis.
Parameter
Nama | Tipe | Wajib | Deskripsi |
---|---|---|---|
WorkloadGroupName | string |
✔️ | Nama grup beban kerja. Dapat ditentukan dengan notasi kurung siku ['WorkLoadGroupName']. |
SerializedPolicyObject | string |
✔️ | Representasi JSON dari kebijakan. * |
*
Kebijakan berikut berlaku untuk grup beban kerja:
- klasifikasi permintaan
- batas permintaan
- batas tingkat permintaan
- penegakan batas tingkat permintaan.
Mengembalikan
Perintah mengembalikan satu baris yang memperlihatkan detail grup beban kerja.
Berikut ini adalah skema output yang dikembalikan:
Nama | Tipe | Deskripsi |
---|---|---|
WorkloadGroupName | string |
Nama grup beban kerja. |
WorkloadGroup | string |
Representasi JSON dari kebijakan. |
Contoh
Mengubah batas tertentu dalam kebijakan batas permintaan
Ubah batas tertentu dalam kebijakan default
batas permintaan grup beban kerja, sambil menjaga batas yang ditentukan sebelumnya tidak berubah.
.alter-merge workload_group default ```
{
"RequestLimitsPolicy": {
"DataScope": {
"IsRelaxable": false,
"Value": "HotCache"
},
"MaxExecutionTime": {
"IsRelaxable": false,
"Value": "00:01:00"
}
}
} ```
Hasil
WorkloadGroupName | WorkloadGroup |
---|---|
Default | {"RequestLimitsPolicy":{"DataScope":{"IsRelaxable":false,"Value":"HotCache"},"MaxMemoryPerQueryPerNode":{"IsRelaxable":true,"Value":8589699072},"MaxMemoryPerIterator":{"IsRelaxable":true,"Value":5368709120},"MaxFanoutThreadsPercentage":{{"IsRelaxable":true,"Value":100},"MaxFanoutNodesPercentage":{"IsRelaxable":true,"Value":100},"MaxResultRecords":{"IsRelaxable":true,"Value":500000},"MaxResultBytes":{"IsRelaxable":true,"Value":67108864}," MaxExecutionTime":{"IsRelaxable":false,"Value":"00:01:00"}},"RequestRateLimitPolicies":[{"IsEnabled":true,"Scope":"WorkloadGroup","LimitKind":"ConcururrentRequests","Properties":{"MaxConcurrentRequests":100}}],"RequestRateLimitsEnforcementPolicy":{"QueriesEnforcementLevel":"QueryHead","CommandsEnforcementLevel":"Database"}} |
Mengubah kebijakan batas tingkat permintaan
Ubah kebijakan default
batas laju permintaan grup beban kerja, sambil menjaga semua kebijakan lainnya tidak berubah.
.alter-merge workload_group default ```
{
"RequestRateLimitPolicies": [
{
"IsEnabled": true,
"Scope": "WorkloadGroup",
"LimitKind": "ConcurrentRequests",
"Properties": {
"MaxConcurrentRequests": 100
}
}
]
} ```
Hasil
WorkloadGroupName | WorkloadGroup |
---|---|
Default | {"RequestLimitsPolicy":{"DataScope":{"IsRelaxable":false,"Value":"HotCache"},"MaxMemoryPerQueryPerNode":{"IsRelaxable":true,"Value":8589699072},"MaxMemoryPerIterator":{"IsRelaxable":true,"Value":5368709120},"MaxFanoutThreadsPercentage":{{"IsRelaxable":true,"Value":100},"MaxFanoutNodesPercentage":{"IsRelaxable":true,"Value":100},"MaxResultRecords":{"IsRelaxable":true,"Value":500000},"MaxResultBytes":{"IsRelaxable":true,"Value":67108864}," MaxExecutionTime":{"IsRelaxable":false,"Value":"00:01:00"}},"RequestRateLimitPolicies":[{"IsEnabled":true,"Scope":"WorkloadGroup","LimitKind":"ConcururrentRequests","Properties":{"MaxConcurrentRequests":100}}],"RequestRateLimitsEnforcementPolicy":{"QueriesEnforcementLevel":"QueryHead","CommandsEnforcementLevel":"Database"}} |
Mengubah kebijakan antrean permintaan
Aktifkan antrean permintaan untuk default
grup beban kerja, sambil menjaga kebijakan batas permintaan dan kebijakan batas laju permintaan tidak berubah.
.alter-merge workload_group default ```
{
"RequestQueuingPolicy": {
"IsEnabled": true
}
} ```
Hasil
WorkloadGroupName | WorkloadGroup |
---|---|
Default | {"RequestLimitsPolicy":{"DataScope":{"IsRelaxable":false,"Value":"HotCache"},"MaxMemoryPerQueryPerNode":{"IsRelaxable":true,"Value":8589699072},"MaxMemoryPerIterator":{"IsRelaxable":true,"Value":5368709120},"MaxFanoutThreadsPercentage":{{"IsRelaxable":true,"Value":100},"MaxFanoutNodesPercentage":{"IsRelaxable":true,"Value":100},"MaxResultRecords":{"IsRelaxable":true,"Value":500000},"MaxResultBytes":{"IsRelaxable":true,"Value":67108864}," MaxExecutionTime":{"IsRelaxable":false,"Value":"00:01:00"}},"RequestRateLimitPolicies":[{"IsEnabled":true,"Scope":"WorkloadGroup","LimitKind":"ConcurrentRequests","Properties":{Scope":"WorkloadGroup","LimitKind":"ConcurrentRequests","Properties":{"MaxConcurrentRequests":100}}],"RequestQueuingPolicy":{"IsEnabled":true},"RequestRateLimitsEnforcementPolicy":{"QueriesEnforcementLevel":\n"QueryHead","CommandsEnforcementLevel":"Database"}} |
Mengubah kebijakan penegakan batas tingkat permintaan
Aktifkan kebijakan penegakan batas tarif permintaan untuk default
grup beban kerja, sambil menjaga semua kebijakan lainnya tidak berubah.
.alter-merge workload_group default ```
{
"RequestRateLimitsEnforcementpolicy": {
"QueriesEnforcementLevel": "QueryHead",
"CommandsEnforcementLevel": "Cluster"
}
} ```
Hasil
WorkloadGroupName | WorkloadGroup |
---|---|
Default | {"RequestLimitsPolicy":{"DataScope":{"IsRelaxable":false,"Value":"HotCache"},"MaxMemoryPerQueryPerNode":{"IsRelaxable":true,"Value":8589699072},"MaxMemoryPerIterator":{"IsRelaxable":true,"Value":5368709120},"MaxFanoutThreadsPercentage":{{"IsRelaxable":true,"Value":100},"MaxFanoutNodesPercentage":{"IsRelaxable":true,"Value":100},"MaxResultRecords":{"IsRelaxable":true,"Value":500000},"MaxResultBytes":{"IsRelaxable":true,"Value":67108864}," MaxExecutionTime":{"IsRelaxable":false,"Value":"00:01:00"}},"RequestRateLimitPolicies":[{"IsEnabled":true,"Scope":"WorkloadGroup","LimitKind":"ConcurrentRequests","Properties":{"MaxConcurrentRequests":100}}],"RequestQueuingPolicy":{"IsEnabled":true},"RequestRateLimitsEnforcementPolicy":{"QueriesEnforcementLevel":"QueryHead","CommandsEnforcementLevel":"Cluster"}} |
Mengubah kebijakan konsistensi kueri
Tentukan opsi yang berlaku untuk model konsistensi kueri.
.alter-merge workload_group default ```
{
"QueryConsistencyPolicy": {
"QueryConsistency": {
"IsRelaxable": true,
"Value": "Weak"
}
}
} ```
Hasil
WorkloadGroupName | WorkloadGroup |
---|---|
Default | {"RequestLimitsPolicy":{"DataScope":{"IsRelaxable":false,"Value":"HotCache"},"MaxMemoryPerQueryPerNode":{"IsRelaxable":true,"Value":8589699072},"MaxMemoryPerIterator":{"IsRelaxable":true,"Value":5368709120},"MaxFanoutThreadsPercentage":{{"IsRelaxable":true,"Value":100},"MaxFanoutNodesPercentage":{"IsRelaxable":true,"Value":100},"MaxResultRecords":{"IsRelaxable":true,"Value":500000},"MaxResultBytes":{"IsRelaxable":true,"Value":67108864}," MaxExecutionTime":{"IsRelaxable":false,"Value":"00:01:00"}},"RequestRateLimitPolicies":[{"IsEnabled":true,"Scope":"WorkloadGroup","LimitKind":"ConcurrentRequests","Properties":{"MaxConcurrentRequests":100}}],"RequestQueuingPolicy":{"IsEnabled":true},"RequestRateLimitsEnforcementPolicy":{"QueriesEnforcementLevel":"QueryHead","CommandsEnforcementLevel":"Cluster"},"QueryConsistencyPolicy":{"QueryConsistency":{"IsRelaxable":true,"Value":"Weak"}}} |
Saran dan Komentar
https://aka.ms/ContentUserFeedback.
Segera hadir: Sepanjang tahun 2024 kami akan menghentikan penggunaan GitHub Issues sebagai mekanisme umpan balik untuk konten dan menggantinya dengan sistem umpan balik baru. Untuk mengetahui informasi selengkapnya, lihat:Kirim dan lihat umpan balik untuk