How to Configure Maximum Number of Concurrent Connections in SQL Server - SQL Server DBA Tutorial

In this video you will learn how to configure Maximum number of concurrent connections in SQL Server using SQL Server Management studio as well as using T-SQL Script. Video also explains step by step process of going through advance options of SQL Server, what is default number of concurrent connection SQL Server allows and pre-requisites of concurrent connection settings to take effect in SQL Server.

Scripts used in the video to Configure Maximum Number of Concurrent Connections in SQL Server

EXEC sys.sp_configure N'show advanced options', N'1'  RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure N'user connections', N'200'
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure N'show advanced options', N'0'  RECONFIGURE WITH OVERRIDE
GO


Configure Maximum Number of Concurrent Connections in SQL Server

No comments:

Post a Comment