Skip to main content

Posts

Showing posts with the label query execution process time

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. /* 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.