Appunti dal sistema
Appunti su sistemi, sviluppo, automazione, database, progettazione IT… e un po’ di gaming quando ne vale la pena. Scritto quando c’è qualcosa che vale la pena condividere.
Before diving into a deep performance investigation — wait stats, execution plans, I/O benchmarks — it’s worth checking whether a simple configuration oversight is behind the problem. One of the most common and highest-impact quick wins in MySQL is query cache sizing. A cache that’s disabled, too small, or incorrectly sized can account for a…
SQL Server runs a lightweight background trace called the default trace that records a wide range of server-level events: database auto-growth events, object creation and deletion, login failures, server configuration changes, and more. It’s often the first place to look when investigating an incident that didn’t make it into the error log. This article shows…
When troubleshooting a slow or unresponsive MySQL instance, the first step is always the same: find out what is happening right now. These quick diagnostic queries use MySQL’s built-in SHOW STATUS and SHOW PROCESSLIST commands to surface the most useful information in seconds — no external tools required. 1. Active Processes and Running Queries SHOW…
SQL Server Agent jobs are the backbone of automated database maintenance: backups, index rebuilds, integrity checks, ETL pipelines. Knowing at a glance when each job last ran and how long it took is essential for fast daily monitoring, especially when managing multiple instances. This query reads directly from the Agent system tables in msdb and…
Indexes are one of the most powerful performance tools in SQL Server — and one of the most overlooked sources of overhead. Every index you create must be maintained on every INSERT, UPDATE, and DELETE operation. Unused indexes cost you disk space, backup time, memory, and write performance, without providing any read benefit. Finding and…
When troubleshooting performance issues on a SQL Server instance, the first step is always to understand what is happening right now: which queries are running, which sessions are blocking others, and where time is being spent waiting. These three T-SQL scripts give you an immediate picture of the current workload using Dynamic Management Views (DMVs)…
Cosa succederebbe se un grande guerriero e una piccola tartaruga si sfidassero in una gara di velocità? Per Zenone di Elea, matematico e filosofo greco del V secolo a.C., il guerriero non raggiungerebbe mai la tartaruga — almeno secondo la logica del suo celebre paradosso. Eppure il buon senso ci dice il contrario. Ecco come…
IT & Sysadmin
Server, reti e automazione: quello che ho configurato, rotto e sistemato.
Vai alla sezione →AI & Dev
Codice scritto a quattro mani con l’AI: esperimenti, strumenti e cosa ho imparato.
Vai alla sezione →Gaming
Giochi, hardware e qualche riflessione a finali conclusi.
Vai alla sezione →Progetti
App e giochi che ho costruito, da MovieMania! a Time Drift.
Vai alla sezione →Archivio
Articoli più vecchi: alcuni datati, tutti ancora qui.
Vai alla sezione →“This is for Everyone”
— Tim Berners-Lee