tags:

views:

12

answers:

0
Q: 

Measure stored procedure duration

Hi, In my application I want to know the execution time for a stored procedure. My pattern is to execute reader and get the data reader and read the results. The reader return immediately and I don’t know the stored procedure execution time. I cannot put the timers after the reader because I want to have an extension method to encapsulate just the execute reader call. Do you have any idea how I can achieve that?

Thanks, Radu

related questions

What do you use to write and edit stored procedures in Oracle?
How do I determine using TSQL what roles are granted execute permissions on a specific stored procedure?
How do I run Oracle plsql procedure from Lisp?
Output parameters not readable when used with a DataReader
How do you create SQL Server 2005 stored procedure templates in SQL Server 2005 Management Studio?
How do I call MySQL stored procedures from Perl?
Are Stored Procedures more efficient, in general, than inline statements on modern RDBMS's?
Default Integer type in ASP.Net from a Stored Procedure
Should data security be performed on the database side?
How do I conditionally create a stored procedure in SQL Server?
Why is parameterized SQL generated by NHibernate just as fast as a stored procedure?
PHP + MySql + Stored Procedures, how do I get access an "out" value?
SQL file encoding in Visual Studio
T-SQL stored procedure that accepts multiple Id values
SQL Server Fast Forward Cursors
Formatting Stored Procedures
Asynchronous Stored Procedure Calls
Stored Procedure and Timeout
Which is better: Ad hoc queries, or stored procedures?
Query a union table with fields as columns.
Standalone tools for debugging stored procedures
What are the pros and cons to keeping SQL in Stored Procs versus Code
LINQ-to-SQL vs stored procedures?
Insert Update stored proc on SQL Server
Is there any list datatype in MySQL stored procedures, or a way to emulate them?