For many organizations, database teams are still measured by the number of tickets they close. 100 tickets closed. 50 incidents resolved. 200 change requests completed. It looks productive. But it…
A database can be completely operational and the business can still be experiencing a serious outage. The database process is running. Connections are available. CPU utilization looks normal. Storage has…
One of the hardest problems in database performance engineering is not finding that a query is slow. It is reproducing why it is slow. A production query may take 30…
A database can be UP, monitored, backed up and highly available — and still be unreliable. That sounds contradictory. It isn’t. For a business-critical database, reliability is not simply about…
Česky na konci článku. For years, database monitoring was mostly about answering simple questions: Is the database up? Is CPU high? Are there blocking sessions? Is there enough disk space?…
Česky na konci článku. PostgreSQL performance tuning is often reduced to changing a few parameters in postgresql.conf. That approach is dangerous. A production database does not become faster simply because…
Česky na konci článku. Database availability is one of the most important responsibilities of a modern Database Administrator. A database can be fast, secure and perfectly backed up, but if…
Česky na konci článku. Database migration is one of the most challenging projects a Database Administrator can be responsible for. Moving a database from one server to another may sound…
