Get Missing Index details from Activity Monitor Screen in SQL to get more performance

Create Missing index using SQL Activity Monitor to process improvement

If you want to improve performance of application then keep view on activity monitor in SQL and go to long executed query line then you can see from recent expensive query window screen . You can see the average duration of query execution.

To get Missing Index details from Activity Monitor Screen in SQL to get more performance you can do following steps.

Show Query execution plan

Missing Index
/*

Missing Index Details from ExecutionPlan1.sqlplan
The Query Processor estimates that implementing the following index could improve the query cost by 93.6536%.
*/

/*
USE [DB_TEST]
GO
CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]
ON [dbo].[GENERALJOURNALACCOUNTENTRY] ([CREATEDTRANSACTIONID])

GO
*/

Once you get index you can create index by directly executing query or you can create index manually. You can create index in query execution process time is very high.