Vincent Prouillet

Hey, it made my day !

Tag: capacity

Get capacity metrics for SQL Server and Oracle

Second round of the capacity metrics SQL Server Size of database : Size of all the tables > 10mo : Current users Current queries Oracle Size of the instance Size of the tablespaces Size of the schemas (only the one above 10MB) Size of the tables (only the one above 10MB) Current users and queries

Get capacity metrics for MySQL and PostgreSQL

Getting capacity metrics for these two dabatases is suprisingly easily. We will get the size of database(s), current users connected and current queries made (and also the size for each tablespace for PostgreSQL). MySQL Size of database : Size of all the tables : Current users and queries If you have the slow query (doc [...]