SQL server 2008 Question:
Download Job Interview Questions and Answers PDF
Do you know Resource governor in sql server 2008?
Answer:
Resource Governor enables the DBA for managing the work load of 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.
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.
Download SQL server 2008 Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Do you know Plan freezing in sql server 2008? | What is Compression - row-level and page-level compression in sql server 2008? |