SQL Server Performance

Stored procedure taking 40 secs, mixture of a cursor 200 variables and so on

Discussion in 'ALL SQL SERVER QUESTIONS' started by Antonio Benildus Muerling, Jul 1, 2012.

  1. Antonio Benildus Muerling Member

    Hi All,

    Thanks for reading this post, please can anyone help me in a stored procedure which is 1800 lines worth of code, being taking 40 seconds to return few rows.

    There are around 200 variables, cursor, a table being referred over and over, which I think with 400000 rows, I believe that the table is filtered with a where clause @variable.

    I could post the code, at your request.

    PS : I do not know the domain knowledge nor the purpose of it.

    Thanks,

    AB.
    Antonio Benildus Muerling, Jul 1, 2012
    #1

  2. Madhivanan Moderator

    What are you doing with a cursor?
    Madhivanan, Jul 1, 2012
    #2

  3. Antonio Benildus Muerling Member

    looping through some records, is the best I can say, loop through it take values and into another intermediary temp table.
    Antonio Benildus Muerling, Jul 1, 2012
    #3

  4. Shehap Moderator

    Might you pass the T-SQL Query to be able to point out the required T-SQL enhancements and Index Optimizations in order to speed it up..?
    Shehap, Jul 2, 2012
    #4

  5. Antonio Benildus Muerling Member

    I cant post the code, as it says the lines of code more than 10000 characters.
    Antonio Benildus Muerling, Jul 2, 2012
    #5

  6. Antonio Benildus Muerling Member

    Guys please see the file attached and let me know, how could I streamline the codes of it.

    Attached Files:

    Antonio Benildus Muerling, Jul 2, 2012
    #6

  7. Antonio Benildus Muerling Member

    Did anyone see the file attached...
    Antonio Benildus Muerling, Jul 3, 2012
    #7

Share This Page