Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Find out the slow running stored procedure [duplicate]

Tags:

sql

stored-procedures

sql-server-2008-r2

sql-execution-plan

Possible Duplicate:
How to find slowest queries

In Sql Server 2008, is there any option to find out which stored procedure running slowly among all (When the no. of stored procedures is very large. Ex: 500)

like image 928
gee'K'iran Avatar asked Oct 06 '22 14:10

gee'K'iran

1 Answers

Hey Kiran Please refer to this question may be it will answer you

How to find slowest queries

like image 108
Sigar Dave Avatar answered Oct 11 '22 11:10

Sigar Dave
Sign in to Comment

Related questions

VB6 inserting file path into SQL FROM clause
A good blobstore / memcache solution
retrieve rows of 1st column based on common data on 2nd column
oracle error: not enough values
What will happen if I kill a huge MySQL InnoDb DELETE Query?
SELECT COUNT within date range
Select Distinct on Inner Join Query filtering by multiple values on a single column?
Magento, programmatically adding category to products in script with SQL
How can I PIVOT TABLE Or CrossTab By Datetime?
decimal rounding in union of sums?
Sql syntax to insert every thousandth positive integer, starting from 1 and up until 1 million?
PHP PDO ODBC - The data types are incompatible in the equal to operator
INSERT IGNORE - How can I tell if inserted?
Insert multiple actors on the same movie with MYSQL
SQL Query for counting number of orders per customer and Total Dollar amount
Inserting Superscript Numbers in MS SQL
How to write transfer with T-SQL
Mysql: How to call sql script file from other sql script file?
Limit results from joined table to one row
Enforcing mutual uniqueness across multiple columns

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!