?
Solved

sql2008 encryption algorithm

Posted on 2012-03-24
1
Medium Priority
?
387 Views
Last Modified: 2012-04-11
Following below are encryption available for db mirroring use in sql2008. I wonder which one of these are provide very strong  to the least encryption? I heard that using strong encryption will use a lot of cpu resources, so I'm thinking to use the most suitable for our environment.

 [ALGORITHM { RC4 | AES | AES RC4 | RC4 AES } ]
0
Comment
Question by:motioneye
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 43

Accepted Solution

by:
Eugene Z earned 2000 total points
ID: 37763216
yes, you are right about CPU resources...
The rest it is up to your environment

check the below articles

Choosing an Encryption Algorithm
http://technet.microsoft.com/en-us/library/ms345262.aspx 

--
for db mirroring
Database Mirroring (OLTP)---a Technical Reference Guide for Designing Mission-Critical OLTP Solutions
http://technet.microsoft.com/en-us/library/hh393563(v=sql.110).aspx

Database Mirroring Best Practices and Performance Considerations
http://technet.microsoft.com/en-us/library/cc917681.aspx


Things to consider when setting up database mirroring in SQL Server.
http://support.microsoft.com/kb/2001270

Database Mirroring Endpoint
http://msdn.microsoft.com/en-us/library/ms179511.aspx

Database Mirroring Transport Security

http://msdn.microsoft.com/en-us/library/ms186360.aspx
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question