Posted inLinux PostgreSQL
LogRotate Policy For PostgreSQL
Learn how to create a log rotation policy for postgresql logs based on size
Posted inErrors
Error/Fix: There is insufficient system memory in resource pool ‘default’ to run this query.
Recently I was reading about Temporal Tables feature that has been introduced with SQL Server 2016. So, as usual, I thought to get the knowledge in practice with my virtual…
Posted inInternals
Myth – Shrinking Log Files is OK
Many times I have seen that DBAs feel like its OK to Shrink Log files in order to release space, and they perform this activity in SQL Agent job. In…
Posted inErrors
Error/Fix: The database owner SID recorded in the master database differs from the database owner SID recorded in database
Recently I received an incident for low disk space on mount point dedicated to system databases on development sql server. So I started checking SQL Server Error logs to find…
Posted inErrors
Error/Fix: SQL Server has encountered 26063 occurrence(s) of I/O requests taking longer than 15 seconds to complete
Recently I received an incident for CheckDB job failure on one of our production server. Job history suggested that the job has been continuously failing for past 15 weeks. But,…
![Result Set of [sp_WhoIsActive]](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2016/12/Log_Activities-02-1.png?fit=1024%2C437&ssl=1)
Posted inPerformance Tuning
Log all Activities using sp_WhoIsActive
It is not a new thing for a DBA to check what's running currently on server in order to figure out issues. My personal favorite tool for finding out current…
Posted inDatabase Administration Errors
SQL SERVER – Fix : Error : The request failed or the service did not respond in a timely fashion
Yesterday, I was working on my office laptop with SQL Server which was installed previous day only, when all of a sudden I received message of machine getting restart due…