Results 1 to 2 of 2

Thread: Tuning a stored procedure

Threaded View

  1. 08-05-2015, 11:41 AM #1
    bhosalenarayan
    bhosalenarayan is offline Registered User
    Join Date
    Aug 2009
    Posts
    23

    Tuning a stored procedure

    Hello,

    I have a procedure that was taking around 11-12 seconds to run on SQL Server 2012 Enterprise edition.

    There is table named fs.performance that has 21995968 records and it is referenced a couple of times in the procedure.

    I analyzed the procedure in DETA and it suggested a couple of indexes on table fs.performance. I created those indexes and the longest this procedure takes to run (tested with different paramaters) is around 5 seconds now.

    This procedure gets called from application using different parameters. It runs fast for some parameters and slow for some other. Please suggest some ways to tune this procedure so that I get the results within under a second

    Attached are the details.

    Thanks in advance.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules