Page History
The Server Inventory report lets you compile a list of SQL Server instances that share up to four seven different properties, such as the SQL Server version and whether you have a clustered instance: Server Name, Server Version, OS Version, Number of Processors, Physical Memory, and Clustered.
| Tip |
|---|
You can use % as a wildcard in the Search Value field. |
When to run this report
Run the Server Inventory report when you need to identify which monitored instances require software or hardware upgrades, or simply want to know how many instances of a SQL Server version are deployed.
Deleted SQL Server instances
When you choose to delete a SQL Server instance, SQL Diagnostic Manager displays the confirmation message, "Would you like to retain the data collected for the selected instance?" When you click Yes , SQL Diagnostic Manager retains data for the instance and includes it in some reports, such as the Server Inventory report.
How SQL Diagnostic Manager calculates metric values on this report
Most values on the Server Inventory report correlate with the related SQL Server metric.
You can access our
| Newtablink | ||||
|---|---|---|---|---|
|
|
- How does SQL Diagnostic Manager gather statistics from monitored SQL Servers? - Solution #00000055
| Scroll pdf ignore | ||||||
|---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...
...