Category Archives: database

How to find total number of read/write on sql server databases

The following SQL will tell you  how many reads and writes the databases on your sql server instances has serviced : SELECT d.Name AS DatabaseName, COUNT(c.connection_id) AS NumberOfConnections, ISNULL(SUM(c.num_reads), 0) AS NumberOfReads, ISNULL(SUM(c.num_writes), 0) AS NumberOfWrites FROM sys.databases d LEFT … Continue reading

Posted in database, sql server | Tagged , , , | Leave a comment

SQL Server recovery using differential backup

One of my DBAs said while trying to restore differential backup he was getting  : Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward … Continue reading

Posted in database, how to, sql server | Tagged , , , , | Leave a comment

Checking on HADR

By now I am sure lot of db2 users have adopted DB2 HADR as one of their high availability solution.  IBM has matured HADR over the last two versions and its becoming more and more robust.  Couple of years ago … Continue reading

Posted in database, db2, how to | Tagged , , , , , | 1 Comment

A quick overview of DB2′s INGEST

As a DB2 DBA or as data integrator we all face a challenge in loading large amount of data into DB2 database while up keeping the 24×7 availability of the tables.  Traditionally we use LOAD or sometimes IMPORT while loading … Continue reading

Posted in database, db2, how to, unix | Tagged , , , , , , , , , , , , , | 1 Comment