Classifications are the internal rules that classify the incoming
requests and route them into a workload groups. This classification is based on
set of user defined function called classifier function. This classifier
function will be created in master database. Once DBA enables the resource
governor on SQL Server Then each and every single session to the server will be
evaluated by the classifier function. It can evaluate various login properties.
- USER_NAME
- HOST_NAME
- WORKSTATION_NAME
- DB_NAME
- SUSER_SNAME
0 comments:
Post a Comment