--- title: "#database-administration articles | Hashnode" description: "Explore 50 articles tagged #database-administration on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/database-administration" --- Tag # #database-administration 50 posts · 42 followers [Rajesh Ravi](https://hashnode.com/@rajeshravi) · [4d ago](https://hashnode.com/posts/zero-downtime-monitoring-in-oem-24ai-patching-your-oms-without-going-blind/6aef30394cf43edb0a6aaa3f) ### [Zero Downtime Monitoring in OEM 24ai: Patching Your OMS Without Going Blind](https://www.rajeshravi.com/zero-downtime-monitoring-in-oem-24ai-patching-your-oms-without-going-blind?utm_source=hashnode&utm_medium=feed) EM 24ai's Zero Downtime Monitoring keeps alerts and notifications live during OMS patching. Here's how it works and what your topology needs to get it. 8 min read · [rajeshravi.com](https://www.rajeshravi.com/zero-downtime-monitoring-in-oem-24ai-patching-your-oms-without-going-blind?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jul 2](https://hashnode.com/posts/union-vs-union-all-how-hidden-sort-operators-slow-down-your-combined-datasets/6a45ab7eaa47703809ba593c) ### [UNION vs. UNION ALL: How Hidden Sort Operators Slow Down Your Combined Datasets](https://tunedinstance.com/union-vs-union-all-how-hidden-sort-operators-slow-down-your-combined-datasets?utm_source=hashnode&utm_medium=feed) Unmasking the duplicate check penalty: Why combining queries can trigger unexpected disk grinding, how to trace performance plan warnings, and when to drop the distinct filter safely. 7 min read · [tunedinstance.com](https://tunedinstance.com/union-vs-union-all-how-hidden-sort-operators-slow-down-your-combined-datasets?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 21](https://hashnode.com/posts/sql-server-linked-servers-how-to-fix-slow-cross-server-queries-and-stop-performance-lag/6a38342c7213a9c51d81bffe) ### [SQL Server Linked Servers: How to Fix Slow Cross-Server Queries and Stop Performance Lag](https://tunedinstance.com/sql-server-linked-servers-how-to-fix-slow-cross-server-queries-and-stop-performance-lag?utm_source=hashnode&utm_medium=feed) Unclogging the cross-server pipeline: Why linking databases makes queries run slow, how to stop SQL Server from pulling millions of rows over the network, and how to write fast remote queries. 6 min read · [tunedinstance.com](https://tunedinstance.com/sql-server-linked-servers-how-to-fix-slow-cross-server-queries-and-stop-performance-lag?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 16](https://hashnode.com/posts/navigating-memory-architecture-buffer-pool-tracking-clerks-and-plan-cache-eviction/6a318d0c1d385f549f9ff40a) ### [Navigating Memory Architecture: Buffer Pool Tracking, Clerks, and Plan Cache Eviction](https://tunedinstance.com/navigating-memory-architecture-buffer-pool-tracking-clerks-and-plan-cache-eviction?utm_source=hashnode&utm_medium=feed) Cracking the code on RAM allocations: How to audit Page Life Expectancy, diagnose buffer pool pressure, and eliminate plan cache bloat. 8 min read · [tunedinstance.com](https://tunedinstance.com/navigating-memory-architecture-buffer-pool-tracking-clerks-and-plan-cache-eviction?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 15](https://hashnode.com/posts/scaling-large-datasets-table-partitioning-architecture-and-sliding-window-purges/6a304de2645165a0bf59a9b4) ### [Scaling Large Datasets: Table Partitioning Architecture and Sliding Window Purges](https://tunedinstance.com/scaling-large-datasets-table-partitioning-architecture-and-sliding-window-purges?utm_source=hashnode&utm_medium=feed) Architecting VLDB storage layers: How to configure symmetrical index alignment, engineer partition functions, and execute instantaneous metadata-only data purges. 8 min read · [tunedinstance.com](https://tunedinstance.com/scaling-large-datasets-table-partitioning-architecture-and-sliding-window-purges?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 15](https://hashnode.com/posts/sql-server-transaction-log-vlf-fragmentation-emergency-triage/6a3038eb6e9657d8e0eb0327) ### [Optimizing Transaction Log Architecture: Mitigating Runaway LDF Files and VLF Fragmentation](https://tunedinstance.com/sql-server-transaction-log-vlf-fragmentation-emergency-triage?utm_source=hashnode&utm_medium=feed) Unpacking .ldf storage engineering: How to audit Virtual Log Files, isolate log truncation roadblocks, and handle emergency disk saturation safely. 10 min read · [tunedinstance.com](https://tunedinstance.com/sql-server-transaction-log-vlf-fragmentation-emergency-triage?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 15](https://hashnode.com/posts/designing-high-performance-indexes-composite-keys-included-columns-and-mitigating-key-lookups/6a304ab199a293ff3878e988) ### [Designing High-Performance Indexes: Composite Keys, Included Columns, and Mitigating Key Lookups](https://tunedinstance.com/designing-high-performance-indexes-composite-keys-included-columns-and-mitigating-key-lookups?utm_source=hashnode&utm_medium=feed) Mastering B-Tree physical alignment: How to engineer optimal column ordering, eliminate costly Key Lookup operators, and balance read optimization against DML write overhead. 7 min read · [tunedinstance.com](https://tunedinstance.com/designing-high-performance-indexes-composite-keys-included-columns-and-mitigating-key-lookups?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 14](https://hashnode.com/posts/sql-server-query-store-architecture-performance-tuning/6a2f0a3ca6e01079be785acf) ### [Query Store Architecture: The Flight Data Recorder for SQL Server](https://tunedinstance.com/sql-server-query-store-architecture-performance-tuning?utm_source=hashnode&utm_medium=feed) Unlocking the database black box: How to automatically track historical execution plans, analyze runtime wait states, and mitigate performance regressions asynchronously. 6 min read · [tunedinstance.com](https://tunedinstance.com/sql-server-query-store-architecture-performance-tuning?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 14](https://hashnode.com/posts/sql-server-index-fragmentation-outdated-statistics-triage/6a2f06b6f4ac10e435235449) ### [Maintaining Engine Health: Triage Index Fragmentation and Outdated Statistics](https://tunedinstance.com/sql-server-index-fragmentation-outdated-statistics-triage?utm_source=hashnode&utm_medium=feed) Optimizing physical and logical data access paths: A deep dive into tracking page splits, auditing modification counters, and updating stale distribution histograms for peak engine efficiency. 7 min read · [tunedinstance.com](https://tunedinstance.com/sql-server-index-fragmentation-outdated-statistics-triage?utm_source=hashnode&utm_medium=feed) [Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 14](https://hashnode.com/posts/sql-server-extended-events-workload-capture/6a2ee91222104da73b25e1d2) ### [Catching the Slowdowns: Capturing Workloads with Extended Events](https://tunedinstance.com/sql-server-extended-events-workload-capture?utm_source=hashnode&utm_medium=feed) Moving past legacy Profiler overhead: How to implement lightweight asynchronous event sessions, leverage server predicates, and safely capture production workloads without thread saturation. 6 min read · [tunedinstance.com](https://tunedinstance.com/sql-server-extended-events-workload-capture?utm_source=hashnode&utm_medium=feed)