Category: Monitoring
-
PC Monitoring con OpenHWMonitor, Home Assistant e Grafana
Se sei un appassionato di gaming su PC, sai bene quanto sia importante ottenere le migliori prestazioni possibili dal tuo hardware. Con la rapida evoluzione dei giochi e della tecnologia, la necessità di ottimizzare il proprio computer per assicurarsi non solo performance eccellenti, ma anche una buona durata dei componenti, è diventata cruciale. Questo desiderio…
-
Monitoring Wait Events of a single Session or Query in SQL Server
Using sys.dm_os_wait_stat is not useful for deep troubleshooting because this view contains wait events for ALL processes/queries running on your instance since last restart. Using command “DBCC SQLPERF (‘sys.dm_os_wait_stats’, CLEAR)” we can reset this view with no restart but on big and stressed instances with many processes and applications running this isn’t a real good…
-
SQL Jobs Monitoring: check last run datetime and duration
A simple query to check rapidly your job’s status and duration. Useful for fast monitoring on many instances. No more thing s to say: this is the code based on msdb..sysjobs and msdb..sysjobhistory. It’s easy if necessary filtering a single job id or jobs durations too long. select job_id, job_name, run_datetime, SUBSTRING(run_duration, 1, 2) +…