Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xpandre
Posting Yak Master
212 Posts |
 Posted - 2010-01-07 : 23:32:14
|
| Hi,Is there any way to find out the time taken for the complete databse to be encrypted after encryption is set on on the database? I mean any query to find out how much time the background job took for that?Thanks and RegardsSam |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
xpandre
Posting Yak Master
212 Posts |
Posted - 2010-01-07 : 23:44:34
|
| oh..Thanks Tara for the prompt reply.So would the performance be slower during encryption, or would it be anyways slower even after the encryption?We had run our load testing procs multiple times when the encryption was going on in background, and it was very slow..almost 100% slower than without TDE.We had to remove the encryption then.Now we are not sure if the test were done while the encryption was on, or after..as we dont know how long the encryption ran..ThanksSam |
 |
|
|
|
|
|
TDE