Since SQL Servers are of complex nature and are subject to changes, either intentionally or not, having the option to check “on the spot” its state along with the details of its properties is a great feature to have for any DBA. Having said that, it’s even better to have all that precious information stored in one single, easily accessible place.
The following is an easy and straightforward guide on how to quickly view the mentioned data.
To access a SQL Server instance details, one must first establish the connection between the application and the desired instance. There are two ways of achieving this goal:
For those who want to discover instances across the network using the SQL manage instance tool, please consult the How to discover SQL Server instances, SSRS, SSAS and SSIS services article for a detailed look into this process.
For this article, the focus of making the connection between the application and an instance will be on the manual connection.
To initiate this process, upon starting the SQL manage instance tool, head over to the Inventory tab and from the Add drop-down menu click Add manually:
In the Connect to SQL Server window, type in the name of an instance in the Server field or choose it from the list by clicking the drop-down button:
In the next step, choose the authentication for the selected instance between two offered choices:
If the windows authentication is selected, simply click the OK button to make a connection.
On the other hand, if SQL Server option is chosen, provide the user credentials along with its password in the matching fields and afterward click OK:
In the following window, select a folder for added instance and click OK:
Once the connection between the application and the instance is established, its details will be shown in the main grid of the Inventory tab. Here, the basic information is sorted by the grid columns:
To view detailed information of the added instance, check its box and click the Instance button:
This action will transform the main grid Overview level into the Instance view level. The in-depth instance details are now sorted by the following two categories:
Under the server category, the basic information is listed in four subcategories:
In the Instance view grid, properties are presented in two columns:
To view thorough property details about any of the presented subcategories, simply click one of them on the left and the information will be displayed in the grid:
Thorough details about the server objects are sorted in four subcategories:
To export properties of any subcategory, select it in the server panel on the left, check them from the grid and from the Export drop-down list select desired file format from the available: DOCX, PDF or XLSX:
For the purpose of this guide, properties are exported into the PDF file format. The result will look like this:
To document all SQL Server properties, please consult the following How to create detailed documentation for SQL Server instances and snapshots article.