how to get execution time of a sqlquery

Pramod Kumar Nandagiri

16y19.4kSQL

hi iam executing this query

select * from orders where Freight=71.97 and 250 > (select count(*) from orders where employeeid=Shipvia)

aginst northwind database of a sqlserver along with the result of this query i want time taken to execute this query in one column

please help me on this

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Karan Patel16y ago
Accepted answer
using System.Diagnostics;
==================================
Stopwatch sw = new Stopwatch();
sw.Start();

// your sql query and your further task

sw.Stop();

MessageBox.Show(sw.Elapsed.ToString());

Ashish Srivastava10y ago

Dear Pramod

DECLARE @startTime datetime,@endTime datetime

SELECT @startTime=GETDATE()

select * from orders where Freight=71.97 and 250 > (select count(*) from orders  where employeeid=Shipvia) SELECT @endTime=GETDATE()  SELECT DATEDIFF(ms,@startDate,@endDate) AS [Duration in millisecs]

mark the answer if it helps you

Check this link

http://www.c-sharpcorner.com/blogs/sql-query-time-execute-check1

kiran kumar16y ago

DECLARE @startTime datetime,@endTime datetime

SELECT @startTime=GETDATE()

select * from orders where Freight=71.97 and 250 > (select count(*) from orders  where employeeid=Shipvia)
SELECT @endTime=GETDATE()

SELECT DATEDIFF(ms,@startDate,@endDate) AS [Duration in millisecs]

mark the answer if it helps you

Pramod Kumar Nandagiri16y ago
HI freind, u have already given this, i used it but, for one query it is not giving same time at every execution , first time it gives some time and second time the execution time changes and third time it is diff

thats why i want to get the time of execution of a query from the sql management studio it self

plese tell me if any commands or function r there to get the executiontime from the sql mamnangement studio please tl\