Post reply

Procedure taking more time to execute

  • July 23, 2008 at 2:44 am

    #189983

    Hi All,

    My Front end people getting time out error in some situation. Also when i see the Profiler its taking around 30Sec of Duration,30Sec of CPU and 234Sec of Reads.

    But if i use SET SHOWPLAN_ALL, it is showing less number of consumption time taken for execute a Procedure.

    I want to know,for this slow down of Procedure any Server level Setting is there?

    ---

  • July 23, 2008 at 6:25 am

    #846960

    It's not really possible to suggest solutions without understanding the problem. You have a query that is running too long. OK. You've got the basic information of duration, CPU and I/O. Great. It's a good start. Now, you need to get three other pieces of information in order to really drill down. You need the execution plan and you need the Statistics Time & Statistics IO. All three come from running the query in Management Studio. They'll show you where the slow down is occurring and you can figure out if it's out of date statistics, bad indexes, poor execution plans, etc.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply