SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database.
- SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases.
- You can use SSMS to deploy, monitor, and upgrade your applications' data-tier components and build queries and scripts.
- It allows you to connect to and manage your SQL Server from a graphical interface instead of using the command line.
- SQL Server ManagementStudio also provides Transact-SQL, MDX, DMX, and XML languageeditors for editing and debugging scripts.
SSMS System Requirements
The current release of SSMS supports the following 64-bit platforms when used with the latest available service pack:
Supported Operating Systems
- Windows 10 (64-bit) version 1607 (10.0.14393) or later
- Windows 8.1 (64-bit)
- Windows Server 2019 (64-bit)
- Windows Server 2016 (64-bit)
- Windows Server 2012 R2 (64-bit)
- Windows Server 2012 (64-bit)
- Windows Server 2008 R2 (64-bit)
- 1.8 GHz or faster x86 (Intel, AMD) processor. Dual-core or better recommended
- 2 GB of RAM; 4 GB of RAM recommended (2.5 GB minimum if running on a virtual machine)
- Hard disk space: Minimum of 2 GB up to 10 GB of available space
A central feature of SQL Server Management Studio is the Object Explorer, which allows the user to browse, select, and act upon any of the server's objects.
- It can be used to visually observe and analyze query plans and optimize the database performance, among others.
- SQL Server Management Studio can also be used to create a new database, alter any existing database schema by adding or modifying tables and indexes, or analyze performance.
- It includes the query windows, which provide a GUI based interface to write and execute queries.