لطفا منتظر باشید ...
Chapter 14: SQL Server Monitoring and Tuning
Reviewpage 486
Name a monitoring feature that sends database information to a Network Management System (NMS).SQL Server 2000 contains MIB files that can be loaded into an NMS so that the NMS can monitor various aspects of SQL Server activity.
Name a SQL Server tool you can use to monitor current SQL Server activity.The Current Activity node of Enterprise Manager and SQL Profiler are two SQL Server tools that monitor current activity.
Several users inform you that database performance levels seem to change right around the time that staff rotations occur. How can you use SQL Profiler to determine if the staff rotation has anything to do with changing performance levels?Run a trace several times a day as staff is rotated in and out. Create or use an existing template that groups activity by users. Analyze the activity to determine if there is a user running inappropriate or intensive queries.
You are concerned about database security. How can you use SQL Profiler to alleviate your concerns?Create a trace that includes some or all of the event classes in the Security Audit collection. Run the trace continuously or intermittently depending on your security needs.
How can you reduce the amount of data collected by a trace?Be selective about which event classes and data columns should be part of a trace. Further restrict the amount of data captured by applying data filters in the Filters tab of the Event Properties dialog box.
Where can trace data be stored?When you create a trace you can instruct SQL Profiler to create a trace file or a trace table. If you don't select a trace table or trace file location, the trace will be lost when SQL Profiler is closed.
As you move through the Index Tuning wizard screens, you see that choosing a script from the Query Analyzer is not an option. What is the most likely reason for this result?You did not open the Index Tuning wizard from Query Analyzer. The script option is available in the Index Tuning wizard only when the wizard is started from Query Analyzer.
How can you start a trace in Query Analyzer?Use SQL Profiler to define the properties of a trace. Then, create a script from the Script Trace option below the File menu. You can create a script for either SQL Server 7.0 or SQL Server 2000. The script trace contains SQL Profiler stored procedures and input parameters necessary to create a trace. Load the script into the Query Analyzer, make some minor modifications as explained in the script file, and run the trace by executing the script.
What application requirement must be met for the application to benefit from a federation of servers?The application must send requests for data or updates to the member server with the most data required to complete the statement.
How must member tables be configured to support distributed partitioned views?Each member table has the same number of columns as the original table, and each column has the same attributes (such as data type, size, and collation) as the corresponding column in the original table.
What are two ways that CPU consumption can be reduced when performing an analysis with the Index Tuning wizard?Any two of the following are acceptable for reducing CPU consumption: lower the level of analysis by selecting the Fast or Medium tuning modes; analyze a smaller workload and fewer tables; run the analysis against a test version of the production server; and run the wizard on a client computer instead of the SQL Server.
The Index Tuning wizard can create indexed views on what SQL Server editions?SQL Server Enterprise Edition and SQL Server Developer's Edition support indexed views. Therefore, the Index Tuning wizard can create indexed views on these platforms. If you run the Index Tuning wizard on another edition of SQL Server, such as SQL Server Personal Edition, the Add Indexed Views checkbox is not available.
