Use built-in reports, activity monitors, and index tuning advisors to identify bottlenecks, deadlocks, and resource-intensive queries.
Unlike the database engine itself—which is the "brain" that stores and processes data—SSMS is the "window" through which you view and interact with that engine. Key Features and Capabilities server management studio
and Azure Synapse Analytics .