You are a database developer for your company's SQL Server 2000 database. The database is installed
on a Microsoft Windows 2000 server computer. The database is in the default configuration. All tables in
the database have at least one index. SQL Server is the only application running on the server.
The database activity peaks during the day, when sales representatives enter and update sales
transaction. Batch reporting is performed after business hours. The sales representatives report slow
updates and inserts.
What should you do?

A. Run system monitor on the SQL Server:Access Methods counter during the day. Use the output from
System monitor o identify which tables need indexes.

B. Use the sp_configure system stored procedure to increase the number of locks that can be used by SQL
Server

C. Run SQL Profiler during the day. Select the SQL:BatchCompleted and RPC:Completed events and
the EventClass and TextData data columns. Use the output from SQL profiler as input to the Index
Tuning Wizard

D. Increase the value of the min server memory option

E. Rebuild indexes, and use a FILLFACTOR of 100

Думаю, что С. Но вот сомнения мучают - может все-таки нет?