Return
-
Title
How many SQL Server logins do I need for Performance Analysis long term repository for multiple m -
Description
If licensing a SQL Server on a per login/connection basis, how many do I need when using Performance Analysis repository with multiple monitored instances ?
-
Resolution
Each monitored instance needs a connection to the long term repository SQL Server. Therefore if you are monitoring 10 SQL Server instances you will need to allow 10 user connections. In addition, you will need to allow an extra connection of each installation of the Performance Analysis client/GUI which will require a connection to the repository to pull back the information that is being collected.