SQL Server Performance

How to improve query performance

Discussion in 'ALL SQL SERVER QUESTIONS' started by tejokrishna, Mar 30, 2012.

  1. tejokrishna New Member

    Hi,

    Iam trying to execute one query. where query inclued many tables (which has primary key and foreign key's). Its taking 5 min 38 sec's long time to execute...

    I found the missing indexes by using dmv query. what I have to do next... to improve the performance of query

    Iam giving details abt tables, keys, indexes and exicuting query also..



    gimme suggetions to improve performance of above query..

    thankx


    Attached Files:

  2. Shehap MVP, MCTS, MCITP SQL Server

Share This Page