How do you use cloud databases? Take the survey.
Options
SQL Monitor - DeadLocks, Extemded Events - Beta. Does it work with SQL2008R2SP3?
RayBH
Posts: 1 New member
I enabled this beta feature from the configuration page. I started receiving a lot of Dead Lock events in quick batched. However, there are no cooresponding dead lock events in the SQL Error Log and the applications are not reporting any errors. Base on data in the Output tabe, the dead locks are parallelism (e_Pipe_WaitNewRow).
The server is a VMWare VM - Windows 2008R2 DataCenter SQL2008R2 StdEd(10.50.6452) with 128GB RAM and 12 Cores. Max DOP = 6, COTP=50.
For example, I have 10 entries all with the same datetime. Each entry has some combination of the 6 processes making up SPID 118. None of them include any SQL fragments. All of them identify the same Line #, Statment Start, ....
Any help or suggestions appreciated.
Thanks
The server is a VMWare VM - Windows 2008R2 DataCenter SQL2008R2 StdEd(10.50.6452) with 128GB RAM and 12 Cores. Max DOP = 6, COTP=50.
For example, I have 10 entries all with the same datetime. Each entry has some combination of the 6 processes making up SPID 118. None of them include any SQL fragments. All of them identify the same Line #, Statment Start, ....
Any help or suggestions appreciated.
Thanks
Tagged:
Answers
Can you send in some examples of what you're seeing?
I re-enabled the Beta on my Dev servers. I have some screen shots from Nov 28 plus SQL Error Log.
If you have a supported serial key you can send them in to support@red-gate.com and we will get back to you; if not (or if you want to) you can add the images here to the forum post.
Kind regards,
Alex
Have you visited our Help Center?