🔍 Query Analyzer

Identify and optimize expensive queries across all platforms

🔥 Top CPU

📖 Top Reads

⏱️ Top Duration

🔄 Top Executions

📉 Regressions

🎯 Missing Indexes

24.5K

Queries/sec

12ms

Avg Duration

156

Slow Queries

Missing Indexes

Regressions

🔥 Top CPU Consuming Queries

CPU: 2.4s

Reads: 125K

Executions: 4,521

Duration: 3.2s

SELECT * FROM Orders o INNER JOIN Customers c ON o.CustomerID = c.CustomerID WHERE o.OrderDate > @StartDate AND c.Region IN (SELECT Region FROM ...

📍 PROD-SQL-01 • Database: ECommerce • Procedure: usp_GetOrdersByRegion

CPU: 0.8s

Reads: 89K

Executions: 12,450

Duration: 1.1s

UPDATE Inventory SET Quantity = Quantity - @Qty, LastModified = GETDATE() WHERE ProductID = @ProductID AND WarehouseID = @WarehouseID

📍 PROD-SQL-02 • Database: Inventory • Procedure: usp_UpdateStock

CPU: 0.6s

Reads: 45K

Executions: 890

Duration: 2.8s

EXEC sp_GenerateMonthlyReport @Month = @p1, @Year = @p2, @IncludeDetails = 1

📍 RPT-SQL-01 • Database: Reporting • Procedure: sp_GenerateMonthlyReport

🎯 Missing Index Recommendations

IX_Orders_CustomerID_OrderDate

Orders (CustomerID, OrderDate) INCLUDE (Total)

-78%

IX_Inventory_ProductID_Warehouse

Inventory (ProductID, WarehouseID)

-65%

IX_Customers_Region

Customers (Region) INCLUDE (Name, Email)

-52%

IX_AuditLog_Timestamp

AuditLog (Timestamp DESC)

-41%

📉 Recent Regressions

usp_GetOrdersByRegion

Duration increased 340% since Feb 20

+340%

usp_SearchProducts

CPU increased 85% since Feb 18

+85%

fn_CalculateDiscount

Reads increased 120% since Feb 19

+120%