Software Applications Programming Errors and solutions.

Index creation from expensive query from SQL You can use Activity monitor of SQL . Then you can find missing index detail from show execution plan by right click on query. Add caption If its ax then you can create it from AOT step provided at the end of video.

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.