|
Коварство экзамена 70-229: Query Tuning
|
|||
---|---|---|---|
#18+
You are a database consultant. One of your customers reports slow query response times for a SQL Server 2000 database, particularly when table joins are required. Which steps should you take to analyze this performance problem? To answer, click the Select and Place button, and then drag the appropriate transaction order choices beside the appropriate transaction steps. (Use only order choices that apply) A. Use the trace file as an input to the Index Tuning Wizard B. Run the trace C. Use SQL Profiler to create a trace based on the SQL Profiler Tuning Template D. Specify that the trace data be saved to a file, and speciy a miximum file size. E. Use SQL Profiler to create a trace based on the SQL Profiler Standard Template F. Replay the trace, and examine the output G. Specify a stop time for the trace Ответ был такой: C, D, G, B, A, F. Но вот следует ли указывать "stop time for the trace" и нужен ли Replay? ... |
|||
:
Нравится:
Не нравится:
|
|||
18.11.2002, 15:31 |
|
Коварство экзамена 70-229: Query Tuning
|
|||
---|---|---|---|
#18+
Думаю что нужно. Иначе как узнать, что проблема "slow query response" решена ? ... |
|||
:
Нравится:
Не нравится:
|
|||
18.11.2002, 18:19 |
|
Коварство экзамена 70-229: Query Tuning
|
|||
---|---|---|---|
#18+
1. Replay - да, можно и так. Но можно и через реакцию Customer'a 2. stop time for the trace? ... |
|||
:
Нравится:
Не нравится:
|
|||
18.11.2002, 18:28 |
|
|
start [/forum/topic.php?fid=34&fpage=64&tid=1552136]: |
0ms |
get settings: |
10ms |
get forum list: |
15ms |
check forum access: |
4ms |
check topic access: |
4ms |
track hit: |
40ms |
get topic data: |
13ms |
get forum data: |
3ms |
get page messages: |
45ms |
get tp. blocked users: |
2ms |
others: | 258ms |
total: | 394ms |
0 / 0 |