首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. You are configuring a database for an inventory application. The hard d
You are the administrator of a SQL Server 2000 computer. You are configuring a database for an inventory application. The hard d
admin
2009-05-19
82
问题
You are the administrator of a SQL Server 2000 computer. You are configuring a database for an inventory application. The hard disks on your server are configured as shown in the exhibit.
The operating system files are located on drive C. Your database will store a maximum of 6 GB of data and requires a maximum of 2 GB of disk space for the transaction log.
You want to optimize database performance. What should you do?
选项
A、Add a 2-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive F
B、Add a 1-GB transaction log to drive C, a 1-GB transaction log to drive D, a 3-GB data file to drive E, and a 3-GB data file to drive F
C、Add a 1-GB transaction log to drive E, a 1-GB transaction log to drive F, a 3-GB data file to drive E, and a 3-GB data file to drive F
D、Add a 2-GB transaction log to drive F, a 3-GB data file to drive D, and a 3-GB data file to drive E
答案
D
解析
Explanation: Basically there are two methods to improve performance in this scenario:
Method 1: put the transaction log file on a separate physical disk.
One way to improve performance and recoverability of your database is to place the data files and the transaction log files on separate disk subsystems, and to use dedicated disks for your data files so that data read and write (I/O) requests are not competing with other I/O requests on those disks. This is (A).
Method 2: data files split across two physical disks
Splitting your data files among a number of disks results in increased I/O performance in particular when multiple controllers are used like in this scenario. This is (D).
To decide which is better we must think about the application. This is an inventory system and we can assume that the queries would be more frequent than additions and update of rows. So we should choose method 2 since it gives the best performance for reading data.
Note: Physical database design involves mapping the logical design onto physical media to allow for the data to be physically accessed and maintained as quickly as possible by taking advantage of the available hardware and software features.
It is important to correctly design the database and to take advantage of hardware and software features early in the development cycle of a database application, because making changes to these components at a later stage it is difficult. Placing log files and the data files on different physical disks, and placing the log file of a drive that does not hold the operating system can improve database performance as it allows the frequently written to log file to exist a disk with its own read/write heads.
Incorrect Answers:
A: In an inventory system data is read more frequently and not so many changes are made to the database. We should optimize the data files not the log file.
B: Placing log files and the data files on different physical disks and placing the log file of a drive that does not hold the operating system can improve database performance as it allows the frequently written to log file to exist a disk with its own read/write heads. In this part of the log file is placed on drive C, which would also hold the operating system.
C: Placing log files and the data files on different physical disks can improve database performance as it allows the frequently written to log file to exist a disk with its own read/write heads. In this solution the log file and the data file are placed on the same physical drive.
转载请注明原文地址:https://kaotiyun.com/show/puhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Whenpeopletalkabouta"north-southdivide"inBritain,theyusuallyrefertohouseprices,employmentandtheratioofprivat
Chinaplanstospendbillionsofdollarsinthenextfewyearstodevelopmediaandentertainmentcompaniesthatithopescanco
Afterthedotcomboomofthe1990s,theworldisabouttoexperienceaboomindots.Over1,000newgenerictop-leveldomainnam
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
Studythefollowingpicturecarefullyandwriteanessaywithin160-200wordsclearlyonANSWERSHEET2.Youressayshouldcover
Asthemini-blogisbecomingincreasinglypopularamongnetizens,italsobecomescommontocreaterumors.Youaresupposedtow
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
Itwassupposedtobethenew-mediaelection.E-mail,blogging,socialnetworkingandtweetingwereexpectedtosurgeinimporta
Tanyaisthesecurityadministratorforalargedistributedretailcompany.Thecompany’snetworkhasmanydifferentnetworkdev
随机试题
公共政策学的创立者是()
关于阔筋膜张肌肌皮瓣逆行切除,以下哪项是错误的
疖热毒蕴结证的主治方剂是
在我国,《民法通则》规定,不属于根据代理权来源不同分类的代理的是()。
税务机关作出的下列行政行为,纳税人不服时应当先申请行政复议,对行政复议决定不服再向人民法院提起行政诉讼的有()。
某同学每周都对自己的学习情况作出小结,分析自己在学习上取得的进步,找出自己的薄弱环节。他的这种行为属于()
张某与王某系多年好友,张某死前立下遗嘱,将自己珍爱的一架古筝赠与王某。张某去世时王某正在国外出差,1年后王某回国方才得知张某已去世,又过了1年王某才得知张某曾将古筝赠与自己,王某能否向张某之子主张返还古筝?()
在人类社会的发展史上,经历了三次科技革命,其标志为( )。
痛苦比快乐更普遍地充斥着人生,痛苦比快乐更能体现人生。快乐是短暂的,甚至是虚构的,而痛苦则更为现实和持久地存在着。痛苦更能使人感悟生命,实现生命的价值。热爱生命的人会比别人感受到更多的痛苦,同时也感受到了更多的生命之欢歌。因此尼采说:与痛苦对抗是最有趣的事
软件测试的目的是()。
最新回复
(
0
)