Configure Resource Pools, WorkLoad Group, and Classifier Function and then enable the Resource Governor

To manage the server workload by restricting resource-intensive you need Configure Resource Pools, WorkLoad Group, and Classifier Function and then enable the Resource Governor

Snapshot Replication

Snapshot Replication to use the company runs a custom application that stores data in a large Microsoft SQL Server 2012 Database, the primary database is hosted in the main office. Each branch office SQL Server hosts a copy of the database, for a solution that will replicate the entire primary database from the main office SQL Server every weekend

UPGRADE ADVISOR

UPGRADE ADVISOR is a To evaluate to prepare for possible conflicts and issues that may arise during or after the migration with a new server and plan to migrate your database from SQL server 2008 to SQL Server 2012