You administer a Microsoft SQL Server 2012 database.
Users report that a billing application becomes unresponsive during busy times of the day.
While investigating, you notice large number of processes taking or waiting for table locks.
You suspect that SQL Server is assigning stronger locks to queries.
You start a SQL Profiler trace.
Which event should you select?
A.
Deadlock graph
B.
Lock: Escalation
C.
Lock: Timeout
D.
Lock: Deadlock
Reckon it should be B
0
0
May “B”
0
0
the correct answer is ‘c’
Lock:Escalation Event Class
The Lock:Escalation event class indicates that a finer-grained lock has been converted to a coarser-grained lock; for example, a row lock that is converted to an object lock. The escalation event class is Event ID 60.
http://msdn.microsoft.com/en-us/library/ms190723(v=sql.110).aspx
Lock:Timeout Event Class
The Lock:Timeout event class indicates that a request for a lock on a resource, such as a page, has timed out because another transaction is holding a blocking lock on the required resource.
http://msdn.microsoft.com/library/ms189107(v=sql.110).aspx
0
0
Lock: Escalation
0
0
which is it? B or C
0
0
“…SQL Server is assigning stronger locks to queries”:
The locks are being escalated from simple locks (fine-grained locks) to complex locks (coarse-grained)… that is a typical scenario of Lock:Escalation
0
0
Just beneath, are quite a few entirely not connected web pages to ours, on the other hand, they are certainly really worth going over.
0
0
Here are a number of the web-sites we recommend for our visitors.
0
0
We came across a cool web-site that you just may well enjoy. Take a search in case you want.
0
0
Although websites we backlink to below are considerably not related to ours, we feel they are in fact really worth a go via, so have a look.
0
0
Here are a few of the web sites we suggest for our visitors
0
1
below you will come across the link to some websites that we assume you must visit
0
0
usually posts some really fascinating stuff like this. If youre new to this site
0
0
below you will come across the link to some web-sites that we think you need to visit
0
0
c
0
0