Resource Governor enables the DBA for managing the work load of Microsoft SQL Server and critical system resource consumption. The limits of CPU and memory which are the incoming sessions to the SQL Server will be controlled by Resource Governor.
The various scenarios that occur when sudden spike in CPU and memory utilization that result in slow responses for querying requests.
The Resource Governor enables the DBA’s to differentiate the workloads and allocates the shared resources which allow the available CPU and memory resources.
Nice information
ReplyDeleteProfessional business web design
Small business website houston