SQL Server Performance

Performance tuning a stored proc

Discussion in 'T-SQL Performance Tuning for Developers' started by nbkr3bi, May 15, 2007.

  1. nbkr3bi New Member


    We have a stored proc which takes data from a database D1 (multiple tables) and inserts it into a temporary table variable. (DECLARE @Table TABLE( .... )
    Then we insert the data from this @Table and insert it into different tables in database D2
    Finally there is a select statement that does a join on all the tables in D2 and displays it.

    This proc is timing out quite often and we need to tune it to reduce the timeouts.
    Any suggestions?
  2. dineshasanka Moderator

    is it executing faster from Query Analyser

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  3. satya Moderator

Share This Page