Just goes to show how performance is actually available. I'm sure there would still be increased latency if it were an iSCSI datastore, you have so much more in between...

Scott D. Jacobson (8/20/2012)

---

Care to give any more information on the datastore? RAID level, HBAs, interconnects? Also, specifically what make and model of SSDs here? I'd think you're using something...

it's great 🙂

both instances on the same VM?

NetApp snapmanager (which incidentally I am not keen on at all) is implemented at the storage level. Native SQL backups or backups using a 3rd party tool such as Redgate...

Hi Todd thanks for the comments, I totally agree, if you're serious about implementing TDE then an external key management service is a must.

The 3rd party products I referred to...

yes i can see that would be a little embarrassing, please don't forget to rate the article if you found it useful

guy.stephens (8/16/2012)

---

I'm surprised there isn't more mention generally about the fact that TDE is only available in SQL Enterprise edition.

This seems to be where it is least needed as the...

Correct you can't drop the user, you change the mapping.

chuck.hamilton (8/16/2012)

---

2) Data in transit. The article does say that TDE only protects data at rest. I just feel that this needs to be emphasized. If you want to protect...

for the images you may be better off with Windows Distributed File System. This is much improved under Windows 2008

Replication does not replicate the database encryption calls, they...

Geoff A (8/16/2012)

---

nice article. key points covered very well.

we use TDE. we have about half the databases encrypted. the others are not.

i noticed less than 5% increase in CPU usage...

I started using C along with Pascal at college in my youth. I think it's a great language very powerful (you can use assembly directly within C). I think it's...

No, the network names have nothing to do with it, it's the instance name that is the restriction. Each machine can only have 1 default instance clustered or not.