Edit

sys.workload_management_workload_classifier_details (Transact-SQL)

  • Article

Applies to: Azure Synapse Analytics

Returns details for each classifier.

Column Name Data Type Description Range
classifier_id int ID of the classifier. Is not nullable.
classifier_type sysname Joinable to sys.workload_management_workload_classifiers. membername
wlm_label
wlm_context
start_time
end_time
classifier_value sysname The value of the classifier. Is not nullable.

Permissions

Requires VIEW SERVER STATE permission.

Next steps

For a list of all the catalog views for Azure Synapse Analytics and Parallel Data Warehouse, see Azure Synapse Analytics and Parallel Data Warehouse Catalog Views. To create a workload classifier, see CREATE WORKLOAD CLASSIFIER. For more information on workload classification, see Azure Synapse Analytics Workload Classification and Workload Importance