When I need do maintenance task on a SQL Server DataBade, usually run the next steps: use dbname; GO –Full backup of DB BACKUP DATABASE dbname TO DISK = ‘Z:\SQLServerBackups\dbname.bak’ ; GO — Reclaim free space of the data base DBCC SHRINKDATABASE ; GO — verify and repair tables and […]
Etiqueta: db
Proyectos y documentació para el aprovechamiento de bases de datos relacionales, NoSQL y orientadas a objetos.
Recently we have low performance in a informix instance and think the main trouble is some store procedures that have some lock waits. This script will help you to catch those sessions: _ERRLOG=error.log _OUTLOG=output.log _TMPTMP=ivan.txt while true do dbaccess sysmaster – ${_ERRLOG}>> 2>&1
Just a copy from a excellent script to get the top sessions in the informix instance: #!/usr/bin/perl -w ###################################################################### # # dbtop # # Quick real-time resource monitor for Informix database servers, # similar in presentation and operation to the Unix ‘top’ command. # Execute with -h for explanation of […]