首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
88
问题
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
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
[A]Marketforglasscraftsisgrowing[B]Dependenceofcomputerdevelopmentonglass[C]Behindtheadaptabilityofglass[D]
Thenewaircraftrepresentsa$250mbetbyBombardierthatMexicocouldprovidenotjustroutinelabourbutmanufacturingthat
You’rearegularcustomerofashop.Youhavefounditsservicewasbad.Writealettertothemanagertocomplainaboutit.
Twomonthsago,yougotajobasaconsultantforHumanResourceServiceCompany.Butnowyoufindthattheworkisnotwhatyou
Theideaisasaudaciousasitaltruistic:provideapersonallaptopcomputertoeveryschoolchild—particularlyinthepoorestp
Insectsaredisappearing.Theworldhas25percentfewerterrestrialinsectsnowthanin1990.Thisincludesthosewerelyon
设置本地连启动WindowsXP系统自带防火墙。
WindowsXP自动创建的账户除了Administrator外,还有()。
随机试题
A、前伸髁导B、前伸切导C、补偿曲线D、牙尖工作(平衡)斜面E、定位平面调整前伸牙合平衡时其斜度不能改变的是
案情:甲公司于1995年获得国家专利局颁发的9518号实用新型专利权证书,后因未及时缴纳年费被国家专利局公告终止其专利权。1999年3月甲公司提出恢复其专利权的申请,国家知识产权局专利局于同年4月作出恢复其专利的决定。2000年3月,甲公司以专利侵权为由对
电梯的停止开关一般称急停开关,按要求在()必须装设停止开关。
根据《招标投标法》规定,开标时检查投标文件密封情况,应当由( )进行。根据《工程建设项目施工招标投标办法》规定,( )的投标文件应被作为废标处理。
根据《公司法》的规定,上市公司由股东大会以特别决议通过的事项有()。
下列商品中,在零售环节需要缴纳消费税的有()。
《国务院办公厅关于深化高等学校创新创业教育改革的实施意见》中指出,到2020年,要建立健全()融为一体的高校创新创业教育体系。
金币本位制条件下,流通中的货币都是金铸币。()
Theathleticprogramisexpectedtobringpublicitytotheschool,attractstudents,fosterstudentunity,andencouragealumni
他放弃出国的机会,这可真奇怪。(Itis…that句型)
最新回复
(
0
)