More queries for performance issues

https://sqlserver-help.com/tag/sys-dm_exec_requests/
SELECT s.session_id ,r.STATUS ,r.blocking_session_id 'blocked by' ,r.wait_type ,wait_resource ,r.wait_time / (1000.0) 'Wait Time (in Sec)' ,r.cpu_time ,r.logical_reads ,r.reads ,r.writes ,r.total_elapsed_time / (1000.0) 'Elapsed Time (in Sec)' ,Substring(st.TEXT, (r.statement_start_offset / 2) + 1, ( ( CASE r.statement_end_offset WHEN - 1 THEN Datalength(st.TEXT) ELSE r.statement_end_offset END - r.statement_start_offset ) / 2 ) + 1) AS statement_text ,Coalesce(Quotename(Db_name(st.dbid)) + N'.' + Quotename(Object_schema_name(st.objectid, st.dbid)) + N'.' + 
 Quotename(Object_name(st.objectid, st.dbid)), '') AS command_text ,r.command ,s.login_name ,s.host_name ,s.program_name ,s.host_process_id ,s.last_request_end_time ,s.login_time ,r.open_transaction_count FROM sys.dm_exec_sessions AS s INNER JOIN sys.dm_exec_requests AS r ON r.session_id = s.session_id CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS st WHERE r.session_id != @@SPID ORDER BY r.cpu_time DESC ,r.STATUS ,r.blocking_session_id ,s.session_id

Packages that may not be necessary on a server (if it’s got low disk space)

select * from v_DistributionPoint dp
left join v_TaskSequencePackageReferences ts on ts.RefPackageID = dp.PackageID
where dp.ServerNALPath like '%UNHAPPYSERVER.DOMAIN%'
and ts.PackageID is NULL
and dp.PackageID not in (
select PackageID from v_DriverPackage
union all
select PackageID from v_BootImagePackage
union all
select PkgID from vSoftwareUpdatesPackage
)
order by 1

Find workstations that should have the client

select Name0 from v_R_System

where Client0 is null and

Operating_System_Name_and0 like '%workstation%' and

DATEADD(hh, cast((LastLogon0 / (600000000))/ 60 as bigint), cast('1601-1-1' as datetime2) ) > DATEADD (DD, -30, GETDATE ())