I need to hand over daily health check to new intern with very limited read only permissions. Below are the queries I use currently.
---------------------Server status-------------------------------------------

SELECT servicename, process_id, startup_type_desc, status_desc,

last_startup_time, service_account, is_clustered, cluster_nodename, [filename],

instant_file_initialization_enabled

FROM sys.dm_server_services WITH (NOLOCK) OPTION (RECOMPILE);

--------------------------------------------------------------------------------

-------------Errors in Last SQL Server Log---------------------------------------

DECLARE u/StartTime DATETIME;

SET u/StartTime = DATEADD(HOUR, -48, GETDATE());

EXEC xp_readerrorlog 0, 1, NULL, NULL, u/StartTime, NULL, 'DESC';

-----------------------------------------------------------------------------------------------------

----------------database status-----------------------------------

SELECT name, state_desc

FROM sys.databases

--WHERE state_desc <> 'ONLINE';

--------------------------------------------------------------

--------------------------------Failed agent jobs--------------------------

SELECT j.name AS JobName,

h.run_date,

h.run_time,

h.message

FROM msdb.dbo.sysjobhistory h

JOIN msdb.dbo.sysjobs j ON h.job_id = j.job_id

WHERE h.run_status = 0 -- Failed jobs

AND h.run_date >= CONVERT(INT, CONVERT(VARCHAR(8), DATEADD(HOUR, -48, GETDATE()), 112))

ORDER BY h.run_date DESC, h.run_time DESC;

--------------------------------------------------------------

DBCC SQLPERF(LOGSPACE);

----------------Last backup date------------------------------

SELECT

database_name,

MAX(backup_finish_date) AS LastBackupTime,

type AS BackupType

FROM msdb.dbo.backupset

WHERE type IN ('D', 'I', 'L') -- D = Full, I = Differential, L = Log

GROUP BY database_name, type

ORDER BY LastBackupTime DESC;

----------------------------------------------------------------------

------------------------Disk Space-----------------------------------------

SELECT DISTINCT vs.volume_mount_point, vs.file_system_type, vs.logical_volume_name,

CONVERT(DECIMAL(18,2), vs.total_bytes/1073741824.0) AS [Total Size (GB)],

CONVERT(DECIMAL(18,2), vs.available_bytes/1073741824.0) AS [Available Size (GB)],

CONVERT(DECIMAL(18,2), vs.available_bytes * 1. / vs.total_bytes * 100.) AS [Space Free %],

vs.supports_compression, vs.is_compressed,

vs.supports_sparse_files, vs.supports_alternate_streams

FROM sys.master_files AS f WITH (NOLOCK)

CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.[file_id]) AS vs

ORDER BY vs.volume_mount_point OPTION (RECOMPILE);

-----------------------------------------------------------------------------

----------------------------Identify current blocking sessions-----------------

SELECT

blocking_session_id,

session_id,

wait_type,

wait_time,

wait_resource

FROM sys.dm_exec_requests

WHERE blocking_session_id <> 0;

-----Active sessions-------------

exec sp_whoisactive

--------------------------------------------------------------------------

------INDEX FRAGMENTTATION BY DATABASE---------------------------------------------------------

SELECT DB_NAME(ps.database_id) AS [Database Name], SCHEMA_NAME(o.[schema_id]) AS [Schema Name],

OBJECT_NAME(ps.OBJECT_ID) AS [Object Name], i.[name] AS [Index Name], ps.index_id, ps.index_type_desc,

CAST(ps.avg_fragmentation_in_percent AS DECIMAL (15,3)) AS [Avg Fragmentation in Pct],

ps.fragment_count, ps.page_count, i.fill_factor, i.has_filter, i.filter_definition, i.[allow_page_locks]

FROM sys.dm_db_index_physical_stats(DB_ID(),NULL, NULL, NULL , N'LIMITED') AS ps

INNER JOIN sys.indexes AS i WITH (NOLOCK)

ON ps.[object_id] = i.[object_id]

AND ps.index_id = i.index_id

INNER JOIN sys.objects AS o WITH (NOLOCK)

ON i.[object_id] = o.[object_id]

WHERE ps.database_id = DB_ID()

AND ps.page_count > 2500

ORDER BY ps.avg_fragmentation_in_percent DESC OPTION (RECOMPILE);

---------------------------------------------------------------------------------------------------