请教俩道题目?

xjj1982 2002-08-11 02:06:13
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好像也对吧!另外怎么就说明有外部分片和内部分片了?
...全文
47 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

34,593

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧