![]() ![]() Obviously I'm assuming so much with your other parameters, but this should give you a good idea how to proceed. ![]() So in other words, if you want to change max pool size to the value 500, your connection string could resemble this: "data source=your_server initial catalog=your_db trusted_connection=true max pool size=500" In your connection string, specify max pool size=. I'm not sure where else to check, I know I have a lot of moving parts here but I'm getting the feeling I'm just missing a max pool setting somewhere. Changed the connection string to use Data Source=PerfSQL02 Initial Catalog=Masked Integrated Security=True Max Pool Size=1000.Stepped through my code alongside SP_WHO2 which gives more information on logical connections, seeing that the # of connections starts at 52 and the script errors with the "Max Pooled Connections reached" error at 152 logical connections.Googled some information on Server 2008, it looks like it can handle more than 100 connections.SSMS Database instance connection properties (it's set to 0 user connections).SQL Connection String in Visual Studio 2010 (it's set to 1000).I could adjust my script to just use a single thread, but I'd prefer to know where I'm missing a max connection setting as that will be more useful to know for future reference. The total number of times it will iterate is 150, however it is stopping at 100 connections and I can't figure out why. NET script running from Visual Studio 2010 that does the following: I'm running SQL Server 2008 R2 SP1, on a Windows Server 2008 box.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |