Resource governor - Sql server 2008

Explain Resource governor in sql server 2008

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.
Plan freezing - Sql server 2008
Plan freezing is a new concept that allows the DBAs to persist plan guides..........
Table Value Parameters (TVP) - Sql server 2008
A user defined tables are allowed between queries using the Table Value Parameters feature of SQL Server 2008...........
Intellisense in sql server 2008
Prior to SQL Server 2008, IntelliSense was available from third-party products. Red-Gate has a pretty good IntelliSense product..........
Post your comment