SQL Server Performance

query taking long time for execution inthis case what should i do Expand / Collapse

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by naga.rohitkumar, Nov 21, 2012.

  1. naga.rohitkumar New Member

    hi all
    1. application team complaining that queries are executing slow and want reason for that in this case what should i do [or ] follow

    2. customer complaining that the data which they are uploading is taking so much of time and continues to the next time with out completion
    (1.) inthis case when they have to upload the next day data customer canelling the previous day data which is still uploding staus
    inthis case what should i follow


    3..mayin this by cheking sp_who2 active [or ] or using dmvs [or ] dealocks what ever the things which may kill the process in activity monitor

    customer dose not want to us to kill any process with out approvalll....

    so please guide or suggest us with root cause by that i can handel this issue woludn't repeat again



    Thanks & Regards
    NAGA.ROHITKUMAR

Share This Page