Ravi Agarwal Recently I worked on an interesting scenario where an incident was reported for very low PLE value. Very low PLE value indicates memory pressure on SQL server and should be fixed to ensure good SQL server performance. First lets check the definitions of PLE and BCHR as per Microsoft BOL: Page Life Expectancy: Indicates the … Read more
Issue Description: While patching SQL server sometimes SQL services fails to come online post patching. It may be due to various reasons like any corruption in system databases, script level upgrade failure for system databases etc. In this post, we will talk about issues that may arise if you have SSISDB (SQL server integration services … Read more
Issue: Recently I encountered a issue where Commvault backups for SQL databases were not happening for several days post database configuration in AlwaysOn availability groups. Scenario: In many organizations, there is a separate backup team to take all types of backups including database backups. During initial configuration there were no databases configured in availability groups and database … Read more