You administer a SQL Server 2008 infrastructure.
You administer two SQL Server 2008 instances named Instance1 and Instance2. Instance1 contains the
Sales database, and Instance2 contains the Accounts database.
A procedure in the Sales database starts a transaction. The procedure then updates the Sales.dbo.Order
table and the Accounts.dbo.OrderHistory table through a linked server.
You need to ensure that the transaction uses a two-phase commit.
What should you do?

You administer a SQL Server 2008 infrastructure.
You plan to design a solution to obtain hardware configurations, such as the number of processors on a
computer and the processor type of all SQL Server 2008 computers.
The solution must meet the following requirements:
It is hosted on the central computer.
It can verify hardware configurations for multiple servers.
You need to select a technology that meets the requirements by using the minimum amount of development effort.
What should you do?

You administer a SQL Server 2008 infrastructure.
The instance contains a database required for the day-to-day business of your company. Users experience
slow response time when they execute reports.
You plan to design a performance monitoring strategy that captures and stores the following data:
Executed Transact-SQL statements and query activity.
Blocking and deadlock information.
Counters for disk, CPU, and memory.
You need to implement the monitoring process by using the minimum amount of administrative effort.
What should you do?

You administer a SQL Server 2008 instance.
You plan to design a monitoring solution for the instance to monitor object usage statistics.
The solution must identify a list of first 10 objects for each of the following components:
Most frequently executed stored procedures and functions
Long running Transact-SQL statements
You need to implement the monitoring solution to minimize performance effect by using the least amount of
administrative effort.
What should you do?