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

1 comment:

  1. the article, and more importantly, your personal experienceMindfully using our emotions as data about our inner state and knowing when it’s better to de-escalate by taking a time out are great tools. Appreciate you reading and sharing your story, since I can certainly relate and I think others can too
    https://shareit.onl/

    ReplyDelete