首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server computer. Users report that the database times out when they attempt to modify data. Y
You are the administrator of a SQL Server computer. Users report that the database times out when they attempt to modify data. Y
admin
2009-05-19
86
问题
You are the administrator of a SQL Server computer. Users report that the database times out when they attempt to modify data. You use the Current Activity window to examine locks held in the database as shown in the following screenshot.
You need to discover why users cannot modify data in the database, but you do not want to disrupt normal database activities. What should you do?
选项
A、Use the spid 52 icon in the Current Activity window to discover which SQL statement is being executed
B、Use the sp_who stored procedure to discover who is logged in as spid 52
C、Use SQL Profiler to capture the activity of the user who is logged in as spid 52
D、Use System Monitor to log the locks that are granted in the database
答案
A
解析
Explanation: The current activity window in SQL Server Enterprise Manager can be used to perform ad hoc monitoring of an instance of SQL Server. This allows for the quick analysis of the volume and general types of activity on the system and can indicate current blocked and blocking transactions, currently connected users on an instance of SQL Server and the last statement executed and locks that are in effect on the database.
In the screen shot of current activity window the icon, labeled spid 51, indicates that a database lock is in place; the second icon, labeled spid 52, can be used to identify the process that is blocking one or more connections; and the third icon, labeled spid 53, can be used to identify the process that is being blocked by another connection
Incorrect Answers:
B: The system stored procedure sp_lock can be used to return a result set that contains information about resources that are locked and the sp_who stored procedure provides information about current SQL Server 2000 users and processes. The information returned by the sp_who procedure can be filtered to return only current non-idle processes. This makes it possible to identify which resources are being locked and which processes are responsible for creating those locks. These stored procedures require more resources and more administrative effort than the Current Activity window. It is therefore not the best answer.
C: The SQL profiler is not the best tool to immediately solve the locking problem. It could be used at a later moment if a long-term solution to the problem is required. SQL profiler would require more system resources and might impact normal database activities.
Note: SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of SQL Server. Data pertaining to an event can be captured and saved to a file or SQL Server table to be analyzed at a later date. It can be is used to step through problem queries to find the cause of the problem; to find and diagnose slow-running queries; to capture the series of SQL statements that led to a problem; and to monitor the performance of SQL Server to tune workloads.
D: SQL Server provides objects and counters that can be used by System Monitor in a Windows 2000 or by Performance Monitor in Windows NT 4.0 to monitor the system performance of computers running an instance of SQL Server. However, these counters are used for statistics and alerts and they cannot, in a direct way, be used to track down the cause of the locking problem.
转载请注明原文地址:https://kaotiyun.com/show/KuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Rao’s,thelegendaryeastHarlemItalianeatery,ismorethanahundredblocksaboveWallStreet.Butwithaclientelethatincl
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
Insteadofstayingwithonecompanyforlife,moreandmorepeoplearechangingtheirjobs.Whatisyouropiniononjobhopping?
Themethodsoftestingaperson’sknowledgeandabilityremainasprimitiveasevertheywere.Afteralltheseyears,education
YouhavejustcomebackfromUKasamemberofaSino-Britishculturalexchangeprogram.Writeane-mailtoyourBritishcolle
MusicfanshaveoftenviewedMicrosoftassomethinglikeabadcoverband,onethatpumpedoutuninvitingfacsimilesofApple’s
MusicfanshaveoftenviewedMicrosoftassomethinglikeabadcoverband,onethatpumpedoutuninvitingfacsimilesofApple’s
Insectsaredisappearing.Theworldhas25percentfewerterrestrialinsectsnowthanin1990.Thisincludesthosewerelyon
如果WindowsXP能够识别网络适配器如何安装网络适配器。
如果WindowsXP不能够识别网络适配器如何安装网络适配器。
随机试题
局部反循环打捞篮是打捞井底()落物的工具。
三叉神经痛患者疼痛的部位在下颌关节区,提示三叉神经疼痛的分支在
案情:2009年3月18日,家住在北京市A区的张老汉在家住在B区的长子张甲家去世,留下两套房产。其一是A区价值20万元的一居室,其二是C区的价值45万元的二居室。长子张甲和次子张乙由于遗产继承发生争议。张乙到A区法院起诉,要求按照法定继承分割遗产,而张甲主
(2004)甲方要求加快某大型公建工程进度,采用以下方法中的哪种是不合适的?
( )能确切地说明数据分布的离散程度和波动规律,是最常用的反映数据变异程度的特征值。
在金融交易中,逆向选择和道德危害产生的根源是()。
以下属于利率衍生工具的是()。
________决定教育目的及相关内容,并决定教育的领导权。
下列事物中,属于历史唯物主义“社会存在”范畴的有()。
下列叙述中正确的是
最新回复
(
0
)