Is there a means in Spotlight to report the overall up time of a SQL instance (i.e. for individual instances and an overall calculation for a collection of selected instances for a report)?
Attached is a script which gives a rough measure of the up time. You will have to edit it prior to running it to choose the desired date range and connection. The connection name is in the internal format which is host_instance_sqlserver for a named instance or host_sqlserver for a default instance.
Spotlight 12.0 now includes a report on the availability of SQL Server. The latest version of Spotlight maybe downloaded from Support Link:
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center