You need a sample of database query activity to discover whether you can speed up transactions. You would like to replay the sample on another SQL Server computer. You need to capture the sample, but you want to minimize any increase to the workload of the server. What should you do?
A. Run Profiler on a client computer. Configure SQL Profiler to monitor database activity and log data to a .TRc file.
B. Run Profiler on the server. Configure SQL Profiler to monitor database activity and log data to a database table.
C. Run System Monitor on a client computer. Configure System Monitor to monitor database activity and log data to a .blg file.
D. Start SQL Server from a command prompt. Specify trace flag 1204 to enable verbose logging.
2.
The company website has grown in popularity, and database utilization has increased. You need to collect data about the utilization of server resources so that you can provide capacity planning. You want to automate the collection process so that information is gathered as quickly as possible. What should you do?
A. Configure System Monitor to collect data and store it in a SQL Server table.
B. Create a job that executes the sp_statistics stored procedure daily.
C. Use SQL Profiler to trace server activity and store the results in tables.
D. Configure alerts to store information in the Windows application event log.
3.
You have a mission-critical application that runs in the context of the company's server. Database activity is high during the day because sales transactions are entered through network point-of-sale terminals. Sales clerks are reporting that transactions are taking too much time and customers are annoyed with the waiting period for updates to information. What would you do to diagnose the situation?
A. Increase the amount of memory on the server.
B. Upgrade the processor on the server or move to a multiple-processor machine.
C. Use sp_configure to increase the number of locks available to the server.
D. Run SQL Profiler in the day and use the output for the DTA.
E. Run SQL Profiler in off-peak times and use the output for the Tuning Wizard.
4.
A user is reporting that a message that says "unable to perform update, batch is in use" is coming from his application. You suspect that another user's data updates are causing locks within the system. What should you do?
A. Restart the SQL Server service to clear all current locks.
B. Run SQL Server Profiler and trace activity to find where the locks are coming from.
C. Use Activity Monitor to locate the user who is performing updates and have the user complete his or her activity.
D. Use System Monitor to observe the SQLServer:Locks counters.
5.
You are trying to locate information about an error that occurred in the database engine several days ago. You know that the server has been rebooted three times since the problem occurred. Where could you look to find the error details? (Select all that apply.)
A. The Windows system log
B. The Windows application log
C. The Errorlog.3 file
D. The Errorlog file
E.SQLAgent.out
F. SQL Server Archive #3 of the Log File Viewer
G. SQL Agent Archive #3 of the Log File Viewer
6.
You are trying to document detailed activity on the server utilization and at the same time use the information gathered to view information about specific tables. What should you do?
A. Configure System Monitor to collect data and store it in a SQL Server table.
B. Create a job that executes the sp_statistics stored procedure daily.
C. Use SQL Profiler to trace server activity and store the results in tables.
D. Configure alerts to store information in the Windows application event log.
