Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Security

max number of symmetric keys in a database

Is there a limit on number of symmetric keys/asymmetric keys/certificates that can be stored in a database?

Is there any effect on performance of the SQL Server if I have too many (few hundreds) symmetric keys in the database?

thanks

[253 byte] By [phani_va] at [2008-1-10]
«« Key Value Pair one per line
»» Percent of unfiltered Grand Total
# 1

I answered this question some time before in this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=160569&SiteID=1. The answer is the same for each key type.

The number of keys will not affect the performance, but using a lot of keys at the same time (having them "opened" in one or more sessions), will naturally increase the space used by the server.

Thanks

Laurentiu

LaurentiuCristofor at 2007-10-3 > top of Msdn Tech,SQL Server,SQL Server Security...
SQL Server
SQL Server Security

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified