Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 26th, 2007, 02:11 AM
Authorized User
Join Date: Sep 2005
Posts: 24
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to vijaykumartaduri Send a message via Yahoo to vijaykumartaduri
Default How to check the performence of a storeprocedure?


Please let me tell how can i check the performance of a SP?

Ex: One of my existing SP was retived result from db so fast, but i dont know now it is retriving result but taking so much time. How should check where exactly the problem is?

Vijay Kumar Taduri
Vijay Kumar Taduri
Old March 26th, 2007, 07:22 AM
Friend of Wrox
Join Date: Oct 2004
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to anubhav.kumar


Use the sql Server profiler, create a new trace and opt for the performance parameters u wish to monitor[SQL batches in ur case] , run the trace on the server and fire your SP, ypu will get useful info from this!

Anubhav Kumar
Old March 29th, 2007, 01:15 AM
Friend of Wrox
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post

There are many factors affecting the performance of SP. May be it worked fast then, because there were less data and not the same works slow bcoause of more data available. May be you can fine tune the SP to some extent knowing which causes it to slow down. Or check the table and have the proper indexes in place that will boost the SP's performance. Still indexing should be done carefully understanding its need and impact.


- Vijay G
Strive for Perfection

Similar Threads
Thread Thread Starter Forum Replies Last Post
compare run times storeprocedure and view trinhvantuyen BOOK: Beginning SQL 0 October 29th, 2008 04:28 AM
PERFORMENCE ISSUE amartya_mandal ASP.NET 1.0 and 1.1 Professional 0 November 8th, 2006 02:22 AM
Storeprocedure and Crystal Reports ctranjith VB Components 1 January 5th, 2005 05:28 AM
How to create trigger in StoreProcedure shailu SQL Server 2000 5 December 22nd, 2004 12:23 AM
Query performence ARahman SQL Server 2000 2 August 25th, 2003 09:35 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.