You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all client computers run Windows XP Professional. The Domain.com network contains a file server named Certkiller -SR10 and a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company.
Domain.com users in the Accounts department use a proprietary application to access the CK_Sales database. After a few months Domain.com users in the Accounts department complain that the application takes a considerable amount of time to perform certain operations. You need to determine which queries that are used by the application are performing poorly. You intend to use SQL Server Profiler to replay the queries.
You need to ensure that your attempt to resolve the problem has the least possible impact on network performance and the performance of Certkiller -DB01.
What should you do?
A.
Create a trace and save the data to a table in the tempdb.
B.
Create a trace and save the data to file on a shared folder on Certkiller -SR10.
C.
Create a trace and save the data to a file on Certkiller -DB01.
D.
Create a trace and save the data to a table in the user database.
Explanation:
You should save the data as a file to minimize the performance impact on the database server.
Incorrect Answers:
A: To minimize the impact of saving the data, you should save the data as a file rather than as a table. Furthermore, saving the data to the tempdb will not ensure that you can replay the data at a later stage as the tempdb is rebuilt every time the database server is rebooted.
B: Saving the data to a network server and replaying the file at a later stage will increase network traffic and will impact on performance for users.
D: To minimize the impact of saving the data, you should save the data as a file rather than as a table.