Help (question from 70-228)

Dear All,
I need your help to answer this question below:
======
You are the administrator of a SQL Server 2000 computer.
The server contains a database named Sales. A company e-commerce
application uses the Sales database to store sales transactions. The
company Web site 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 SQL Server Agent job that executes the sp_statistics stored
procedure daily and places the results in a text file
c. Use SQL Profiler to trace server activity and store the results in
SQL Server tables
d. Configure SQL Server alerts to store information in the Windows
application event log
======
Thanks
Robert LieI believe the answer is a) The reason is that a) is the only choice that
covers the whole server, to elaborate
b) gives the information on indexes, so you cannot perform capacity planning
from it
c) gives SQL Server commands executed but does not give such things as CPU
usage, disk usage ect
d) gives alert based upon a certain event, so that event has to occur before
its fired.
a) With a however you can configure it to report usage of server stuff i.e.
CPU Usgage, memory usage ect over a specific time period, i.e. every 10
seconds.
Anyone with anything different ?
Peter
"Robert Lie" wrote:

> Dear All,
> I need your help to answer this question below:
> ======
> You are the administrator of a SQL Server 2000 computer.
> The server contains a database named Sales. A company e-commerce
> application uses the Sales database to store sales transactions. The
> company Web site 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 SQL Server Agent job that executes the sp_statistics stored
> procedure daily and places the results in a text file
> c. Use SQL Profiler to trace server activity and store the results in
> SQL Server tables
> d. Configure SQL Server alerts to store information in the Windows
> application event log
> ======
> Thanks
> Robert Lie
>