首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
91
问题
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]Butworkisunderwaytogetcomputerstocapturehumanlifeandrememberitaspeopledo—recallingbitsofexperiencethata
Inthissection,youareaskedtowriteanessaybasedonthefollowinginformation.Makecommentsandexpressyourownopinion.
OnCustomerServiceWriteanessayof160-200wordsbasedonthedrawing.Inyouressay,youshould1)describethedraw
Writeanessaybasedonthefollowingcharts.Inyourwriting,youshould1)describethefollowingdiagrams,and2)g
Writealettertoacompanydecliningajoboffer.Inyourletter,youshouldappreciatethejoboffer,andstateyourreason(s)
WhileAmericanshavebecomeevermoredependentuponelectricityintheirdailylives,acrucialpartofthesystemthatsupport
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
Whethertheeyesare"thewindowsofthesoul"isdebatable;thattheyareintenselyimportantininterpersonalcommunicationis
在【安全中心】窗口中,设置windows防火墙,允许“文件和打印机共享”。
随机试题
催化剂使用寿命短,操作较短时间就要更新或活化的反应,比较适用()反应器。
A、40%~60%B、50%~70%C、60%~80%D、80%E、90%使用环氧乙烷灭菌器,灭菌物品装载量不应超过柜内总体积的()
某县人民政府因一重点企业A公司建设需要,决定对其辖区内的某村村民予以集体搬迁。该村大部分村民(计60户)不服县政府决定,准备向人民法院提起行政诉讼。若该村60户村民向法院提起行政诉讼,则本案的第三人是:
下列关于房地产经纪机构经营模式的表述中,错误的是:()。
以下哪项不属于贷款效益性调查的内容?()
按我国会计准则的规定,外币财务报表折算为人民币报表时,所有者权益变动表中的“未分配利润”项目应当()。
【2019上】在西方音乐发展史上,出现了许多具有重要影响的音乐家。下列选项中,被誉为“交响曲之父”的作曲家是()。
以下各项中,哪年的该省净增人口数量最少( )。2001年—2005年期间,福建总人口约增长了( )。
设f(x,y)=则f(x,y)在(0,0)处().
若Cactle的命中率为0.95,且Cactle的速度是主存的5倍,那么与不采用Cactle相比较,采用Cache后速度大致提高到______倍。
最新回复
(
0
)