16.2. Classifier function
When a user or application connects to a SQL Server instance, the logon process includes two major steps before the session is established: authentication, followed by the firing of any logon triggers. When Resource Governor is enabled, a third step is included for classifying the connection using the classifier function. The process is summarized in figure 16.2.
Figure 16.2. The logon process with Resource Governor enabled consists of authentication, logon triggers, and workload classification.
Given the integration of the classifier function within the logon process, the efficiency of the function becomes a crucial ...
Get SQL Server 2008 Administration in Action now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
