请教俩道题目?
Your users report that your database application takes an excessive amount
of time to complete an operation.
Over time, with the addition of new rows and changes to existing rows, the
situation has worsened.
You suspect that the tables are not optimally indexed. You plan to use the SQL
Server Profiler Create Trace
Wizard to find out the cause of the problem.
What should you use the Create Trace Wizard to do? (Choose two.)
A. Find the worst performing queries.
B. Identify scans of large tables.
C. Identify the cause of a deadlock.
D. Profile the performance of a stored procedure.
E. Trace Transact-SQL activity by application.
F. Trace Transact-SQL activity by user.
Answer: A, B
#39.You have a table with a clustered primary key. The table is used frequently
for both queries and data modifications.
As part of a review of data storage and disk utilization, you run the DBCC
SHOWCONTIG statement. The
statement provides the following output:
- Pages Scanned ……………………?. ……………………?. :158
- Extents Scanned ……………………?. ……………………?.: 21
- Extent Switches ……………………?. ……………………?.: 20
- Avg. Pages per Extent ………………?. ……………………?.: 7.5
- Scan Density [Best Count:Actual Count]: ……………………?.95.24% (20:21]
- Extent Scan Fragmentation ……………………?. …………? 4.76%
- Avg. Bytes Free per Page ……………………?. ………………: 408.4
- Avg. Page Density (full) ……………………?. ………………? 94.95%
What does this output tell you about how the data is stored? (Choose all that
apply.)
A. The table is not externally fragmented.
B. The table is not internally fragmented.
C. The number of extent switches is excessive.
D. The row size does not efficiently fit on a page.
E . The IAM page does not reflect the actual extent usage.
Answer: A,B
这个题E好像也对吧!另外怎么就说明有外部分片和内部分片了?