SQL Server Performance

Performance Issue related to Stored Procedure

Discussion in 'General Developer Questions' started by SQL2000DBA, Jan 20, 2006.

  1. SQL2000DBA New Member

    Hi Everybody,

    I have one issue related to stored procedure peformance.Actually i have stored procedue which is having code having SQLDMO codes for creating SQL Server object,establishing connection,Get a pointer from the Databases collection for the current database and performing data insert.

    Issue is that Whenever i call above logic stored procedure first time, it is taking lots of time to return data but from second tim onwards performance of stored procedure is very good. Do you know why this is happening.

    Thanks and Regards
    Ravi K
  2. Madhivanan Moderator

    First time it takes time to catche execution plan in the memory so that successive calls will be faster

    Madhivanan

    Failing to plan is Planning to fail
  3. satya Moderator

    What kind of other activity is on the server?
    Check if any other jobs or processess are interacting with this process and taking performance effect.

    Best thing is to check the execution plan from query analyzer for indexes usage.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page