sys.workload_management_workload_classifier_details (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database yesAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

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 SQL Data Warehouse and Parallel Data Warehouse, see SQL Data Warehouse and Parallel Data Warehouse Catalog Views. To create a workload classifier, see CREATE WORKLOAD CLASSIFIER. For more information on workload classification, see SQL Data Warehouse Workload Classification and Workload Importance