You basically have to query that FIFO ring buffer.

Jonathan goes into good detail about how to parse / query the data. Hope you like XML 😀

https://www.sqlskills.com/blogs/jonathan/extended-events-ring_buffer/

Thanks for advice Gail and Brandie

Guys just a quick question for those bloggers out there, do you have a section on your website about copyright that protects your writing?

SQLRNNR (7/26/2016)

---

SQLRNNR (7/26/2016)

---

BLOB_EATER (7/26/2016)

---

Hey guys I was wondering if someone could confirm if the experiment that I am doing below is what one would expect from enabling TDE:

Before enabling TDE...

thanks Gail and Hugo. I'm off to do the write up now.

Sean Lange (7/26/2016)

---

BLOB_EATER (7/26/2016)

---

Hey guys I was wondering if someone could confirm if the experiment that I am doing below is what one would expect from enabling TDE:

Before enabling TDE...

Hey guys I was wondering if someone could confirm if the experiment that I am doing below is what one would expect from enabling TDE:

Before enabling TDE I would find...

For Azure VMs you can do it via the portal. see the attached screen shot.

I Don't think you can switch off a logical server.

Grant Fritchey (7/19/2016)

---

Doctor Who 2 (7/19/2016)

---

Hi Steve,

Tonight I have a chance to go through the MSDN article you've posted in response to my question. It looks as though I need...

I'm with Kevin on this one - Grants pending = 40 does indicate an issue ( I have seen this coupled with resource semaphore waits)

PLE does get mis-interpreted if you...

what john said

https://msdn.microsoft.com/en-GB/library/ms189094.aspx

SELECT ProductID, OrderQty, SUM(LineTotal) AS Total

FROM Sales.SalesOrderDetail

WHERE UnitPrice < 4

GROUP BY ProductID, OrderQty

ORDER BY ProductID, OrderQty

OPTION (MAXDOP 2);

you felt that it was low compared to your baseline?

Eddie Wuerch (6/9/2016)

---

We use TDE with an HSM for several multi-TB highly-transactional databases.

Once you set up and enable the encryption, it will run silently in the background encrypting the database...

The attached JPEG made me a giggle...:-P