SQL Complete, which is one of the most functional add-ins, used to write and format SQL queries in SSMS and VS.SQL Tools can be used to automate development and deploy databases with the help of dbForge DevOps Automation. The tools are useful for any Microsoft SQL Server developer because they are integrated into SSMS, expanding it with the missing functionality, to perform a lot of routine tasks. configuring and monitoring AlwaysOn availability groupsĭbForge SQL Tools is a multi-functional toolkit for SQL Server.database engine log shipping configuration and monitoring.There are a bunch of other functions in SSMS, including the following: What is more, in SSMS, it is also possible to see active queries using Activity Monitor, but in general, it isn’t the best option to monitor a database and a database server.Īlso, to monitor performance, you can use Profiler and Extended events in SSMS. In SSMS, there is also a possibility of managing the Agent and designing databases through a database diagram.

Sql toolbelt redgate