Introduction; The Data Migration Assistant (DMA) tool is a Microsoft utility designed to simplify the migration of databases from older SQL Server versions or on-premises environments to newer versions or…
Read MoreIntroduction: The user is experiencing a high CPU usage spike on their SQL Server instance, leading to performance degradation. The objective is to identify the root cause of the CPU…
Read MoreIntroduction: The user has reported a sudden memory usage spike on their SQL Server instance, resulting in degraded performance. You need to troubleshoot and identify the root cause of the…
Read MoreIntroduction/Issue:While working with Docker containers in our environment, we encountered an issue where certain containers were failing to start, throwing cryptic error messages. This disrupted the workflow and required immediate…
Read MoreIntroduction/Issue:During a period of increased traffic, our application faced performance bottlenecks due to insufficient resources. Manual intervention for scaling was inefficient, so we decided to implement auto-scaling for our Kubernetes…
Read MoreSELECT dha.source_order_number, dha.order_number, dfla.status_code, dfla.source_line_number FROM fusion.doo_headers_all dha, fusion.doo_fulfill_lines_all dfla, fusion.wsh_delivery_assignments wda, fusion.wsh_new_deliveries wnd, fusion.wsh_delivery_details wdd, fusion.inv_material_txns imt WHERE dha.header_id=dfla.header_id AND dfla.fulfill_line_id=wdd.source_shipment_id AND wdd.delivery_detail_id=wda.delivery_detail_id AND wda.delivery_id=wnd.delivery_id(+)…
Read MoreSELECT esi.inventory_item_id, esi.item_number, esi.organization_id, inv.organization_code, esi.enabled_flag, esi.end_date_active, ohq.transaction_quantity onhand_qty FROM fusion.egp_system_items_b esi, fusion.inv_org_parameters inv, fusion.inv_onhand_quantities_detail ohq WHERE inv.organization_id=esi.organization_id AND inv.organization_id=ohq.organization_id AND esi.inventory_item_id=ohq.inventory_item_id
Read More1. Introduction This document provides a detailed investigation and resolution report for the File Share Witness server issue observed in the failover cluster for the server TEST. It outlines the findings, steps…
Read MoreIntroduction This document provides a detailed procedure for diagnosing and resolving the issue of a SQL Server queue that automatically disables itself after being re-enabled. This behavior is often caused…
Read MoreIntroduction The DBCC CHECKDB command is an essential tool in SQL Server for ensuring the physical and logical integrity of databases. It helps detect any corruption in the database structure,…
Read More