March 23, 2012 at 9:56 am
I am getting this resource lock [ENCRYPTION_SCAN] on the TEMPDB... I do not nor have I ever had encryption on this server.
Any help out there?
Tim
March 23, 2012 at 2:20 pm
Select * from sys.databases where is_encrypted = 1 returns no rows?
If a single database is encrypted using TDE then tempdb is encrypted.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 23, 2012 at 2:22 pm
Yes I understand this... please note that we do not nor have we ever encrypted any database in our server.
March 23, 2012 at 2:26 pm
i ran this ... zero results
SELECT DB_NAME(e.database_id) AS DatabaseName,
e.database_id,
e.encryption_state,
CASE e.encryption_state
WHEN 0 THEN 'No key present - encryption unavailable'
WHEN 1 THEN 'Unencrypted'
WHEN 2 THEN 'Encryption in progress'
WHEN 3 THEN 'Encrypted'
WHEN 4 THEN 'Key change in progress'
WHEN 5 THEN 'Decryption in progress'
END AS encryption_state_desc,
c.name,
e.percent_complete
FROM sys.dm_database_encryption_keys AS e
LEFT JOIN master.sys.certificates AS c
ON e.encryptor_thumbprint = c.thumbprint
i ran this...
DBCC TRACESTATUS
resulted in this...
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
here is the version ... (SELECT @@VERSION)
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)
Mar 29 2009 10:11:52
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
March 23, 2012 at 2:27 pm
The only resource I can find that mentions this lock type is this and it says:
DATABASE.ENCRYPTION_SCAN = TDE encryption synchronization.
I'd love to be able to give you more than that.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 23, 2012 at 2:31 pm
tim-407748 (3/23/2012)
DBCC TRACESTATUS
Why did you run this? Running this will only get you trace flags set for the current session. If you wanted to all trace flags enabled you want
DBCC TRACESTATUS(-1)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 23, 2012 at 2:49 pm
we are not using TDE... thanks for trying
March 23, 2012 at 2:51 pm
regarding the trace... someone asked me to provide that info... i do not know how that would even help them but i ran the one you said and got the same results
March 23, 2012 at 3:13 pm
I wouldn't expect you to get anything back form TRACESTATUS that you didn't already know about. I'm checking all my resources to see if I can find anything about this, that isn't related to TDE, but I'm not holding out much hope.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy