sysdaemon / sqlmonitor Goto Github PK

The Database will be design to hold all information about the compiled SP, views and Tables.
As part of the design, the database need to be strong schema designed too.
It means that the Tables, Views and Stored Procedures need to be separated by a schema name (i.e., Disk, Sys, Instance, IO, NIC and CPU).

Display the size of each user and system databases on the current instance

select DATEDIFF(DAY, sqlserver_start_time,convert(datetime,getdate(),103)) AS ServerUpTime from sys.dm_os_sys_info

By knowing the amount of disk space available in your server, you'll have more control of how the space is used and the growth rates.

• Definition: The percentage of available disk space in use.
• Target: Ensure sufficient free disk space to avoid issues related to running out of space.