Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 T-sql analysis

Author  Topic 

vahidam
Starting Member

13 Posts

Posted - 2010-03-16 : 02:06:55
hi all
i want to analysis my store_procedures and queries?how do i do it?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-16 : 03:52:57
use sql profiler or execution plans

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

thewebhosting
Starting Member

17 Posts

Posted - 2010-04-11 : 02:27:21
Hi,

SQL Profiler is the best to analyze the stored procedure. Refer this article on How to use it...

http://msdn.microsoft.com/en-us/library/ms979207.aspx

Go to Top of Page
   

- Advertisement -