首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
71
问题
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://jikaoti.com/ti/0wO7FFFM
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Chinaplanstospendbillionsofdollarsinthenextfewyearstodevelopmediaandentertainmentcompaniesthatithopescanco
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
Itneverrainsbutitpours.Justasbossesandboardshadfinallysortedouttheirworstaccountingandcompliancetroubles,an
Directions:Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressy
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
SupposeyouarethedeanofEnglishDepartmentofNanfangUniversity,andoneofyourseniorstudents,ZhangQuan,isentrusted
Themethodsoftestingaperson’sknowledgeandabilityremainasprimitiveasevertheywere.Afteralltheseyears,education
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
随机试题
下列物质属于水溶性的色素的是()。
在性质判断中,存在周延性问题的项有()
了解肾脏积水的严重程度,下列检查哪项意义不大
A.目眩赤B.白睛赤C.白睛变黄D.眼睑红肿湿烂E.目窠红肿黄疸可见
资产分为流动资产和固定资产两部分。()
资产负债表日后发生的调整事项,应当如同资产负债表所属期间发生的事项一样,作出相关账务处理,并对资产负债表日已编制的会计报表作相应的调整。()
根据《票据法》的规定,下列关于票据伪造的表述中,正确的是()。
现今一届奥运会的会期一般是多少天?(厦门大学2010翻译硕士)
NarratorListentopartofadiscussioninanastronomyclass.Nowgetreadytoanswerthequestions.Youmayuseyour
ThefirstmentionofslaveryinthestatutesoftheEnglishcoloniesofNorthAmericadoesnotoccuruntilafter1660—somefor
最新回复
(
0
)