Home
6.
Where does Profiler store its temporary data in SQL Server 2005?

In the directory stored in the system variable TEMP.

Profiler uses the location specified for the TEMP system variable.

7.
What is the Service Broker Identifier ?

A GUID that identifies the database on which Service Broker is running. Each database has a Service Broker identifier. This is a GUID in the service_broker_GUID column that identifies the databases on which Service Broker is running. It ensure that messages are delivered to the right database.

8.
How are modified extents tracked in SQL Server 2005 (which internal structures)?

Differential Change Map and Bulk Change Map There are two internal structures that track extents modified by bulk copy operations or that have changed since the last full backup. They are the Differential Changed Map (DCM) and the Bulk Changed Map (BCM).

9.
What does the Log Reader agent in SQL Server 2005 replication do?

This agent reads the publisher log for transactions to send to the distributor. This agent is tasked with reading the transaction log in transactional replication and moving those transactions that need to be replicated to the distributor.

10.
What is the cost threshhold for parallelism in SQL Server 2005?

This is the number of seconds that a serialplan cannot exceed if it is to be used. A parallel plan is used if the estimate exceeds this value. This is the threshold at which SQL Server determines whether a serial or parallel plan is to be used. When SQL Server calculates that a serial plan exceeds the threshold, it will elect to use a parallel plan instead.