SQL Connection - Process or Thread ???
-
Howdy, Does anybody know whether the SQL max connections metric is process or thread based? ie If I have an SQL server with up to 3 connections and am running an app which sporns threads which connect to the database will the app have trouble upon more than 3 concurrent threads executing. If the connections are process based then this architecture will do fine. If howver SQL connections are measured on a thread basis then I'm going to have to rewrite the app. Thanks, Damian Del Campo
-
Howdy, Does anybody know whether the SQL max connections metric is process or thread based? ie If I have an SQL server with up to 3 connections and am running an app which sporns threads which connect to the database will the app have trouble upon more than 3 concurrent threads executing. If the connections are process based then this architecture will do fine. If howver SQL connections are measured on a thread basis then I'm going to have to rewrite the app. Thanks, Damian Del Campo
I've just found out that the magical number of '5 connections' isn't a licensing issue as I thought it was but that it is a 'maximum recommended'. Thus I don't have a problem anymore !!!!! BTW, this recommendation is apparently due to performance degradation for more than 5 connections. Is this true? I thought the only difference between MSDE and MSSQL was the management tools that come with MSSQL as the install size, structure and location seems to be identical. Thanks anyway to anybody who would have offered to help with my problem, which is no longer a problem. Damian