![]() ![]() You may have to change default TCP/IP socket settings for the operating system and the computer that is running SQL Server to deal with the higher stress levels. Turning off pooling can cause the underlying SQL Server network driver to rapidly open and close new socket connections to the computer that is running SQL Server. This article describes certain TCP/IP settings that you may have to adjust under these conditions. When you disable pooling, the stress on the underlying SQL Server network library may be increased if your application frequently opens and closes connections. ![]() When you use the SQL Server ODBC driver, the SQL Server OLE DB provider, or the managed provider, you can disable connection pooling by using the respective application programming interfaces (APIs). Microsoft SQL Server 2005 Standard Edition Microsoft SQL Server 2005 Developer Edition Microsoft SQL Server 2005 Enterprise Edition Microsoft SQL Server 2005 Express Edition Microsoft SQL Server 2005 Workgroup Edition More. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |