A comprehensive range of tools are available for SQL performance monitoring. You can tune the database design and monitor events in the server. The set of tools you select and use depends on whether you want to monitor or tune the server. The first tool you get is the built-in functions. It will display the snapshot statistics for all server activity from the time it was started. Check the number of connections including the attempted connections.
The database tuning advisor will analyze the performance of Transact-SQL statement. The database experimentation assistant tool is for A/B testing. It evaluates the target version of server database engine. Get a report on comparative analyzes metrics if you recently upgraded to a newer SQL version. Use the error log tool to get a report on server and operating system events. This log will help you troubleshoot server related problems. The extended events tool is a performance monitoring system. You can create, analyze, display and modify your session data. There are many other such tools for monitoring the performance of SQL Server.