Working with a couple of databases that needed TDE I noticed when I enabled one of them that it was stuck on “encryption in progress” for quite a while. Using the following query I confirmed the following: (source: https://msdn.microsoft.com/en-us/library/bb677274.aspx) My … Continue reading
Tags: SQL Server
Related Articles
2 Toad for SAP Solutions videos on database and data
SAP management. Verse 11 in the 12 Days of … Our gift to you this season is wrapping up our favorite blogs about a product into a collection, with a song to go with each! Each week in December, stay ...
When Using Availability Group Listeners, Why Can I See Non-AG Databases?
Yep. This is actually by design; and is because listeners can be tricky little fellas. When using a SQL Server Availability Group Listener, you can see any databases on the server that is hosting the...
Oracle Identifying and Reducing Redo Allocation Latch Contention
Identify Contention The following query determines the miss ratio and the "immediate" miss ratio for redo log latches. Col MISS_RATIO format 999.99Col IMM_MISS_RATIO format 999.99 SELECT substr(ln.na...