Introduction / Issue In modern cloud environments, infrastructure reliability depends heavily on continuous monitoring. Virtual machines, storage accounts, databases, and network components must remain healthy to ensure uninterrupted application availability. However,…
Read MoreIntroduction / Issue Accidental file deletion is a common risk in production environments. Even experienced administrators can mistakenly remove critical files during maintenance activities. In one instance, important application configuration…
Read MoreIntroduction This document explains how to configure a normal Oracle Data Guard physical standby in Oracle Database 23ai, where the primary database is a Non-CDB and the standby database is…
Read MoreIntroduction High availability and predictable disaster recovery are critical in any Oracle production environment. While managing Data Guard manually via SQL*Plus is possible, the number of manual steps during incidents…
Read MorePrerequisites: a. Oracle Linux 7.9 b. Oracle 19c database (should be 19.3 or higher version), Check using… SELECT target_version AS RU_VERSION FROM dba_registry_sqlpatch WHERE action = 'APPLY' ORDER BY action_time…
Read MorePrerequisite: 1. MS SQL Server with a SQL Authenticated User. CREATE LOGIN Sivakumar WITH PASSWORD = 'Doyen@123', CHECK_POLICY = OFF; SELECT name, type_desc,…
Read MoreParameter Sniffing Issue in SQL Server and Its Resolution Parameter Sniffing Issue in SQL Server and Its Resolution
Read MorePerformance Tuning of Slow Running Queries in SQL
Read MoreIntroduction: Transaction log growth is a common operational challenge in SQL Server environments. Uncontrolled log file growth can lead to disk space issues, performance degradation, and operational risks. This blog…
Read MoreIntroduction Performance issues in SQL Server rarely appear overnight. They build gradually—hidden behind rising CPU usage, growing waits, slow queries, or storage bottlenecks. Effective performance monitoring helps DBAs move from reactive firefighting…
Read More