mardi 30 décembre 2014

How to calculate SQL server stored procedure execution time

I have a stored procedure. I want to check how much time it takes to execute. Please note that I don't have access to profiler. I am using SQL server 2005


I tried using the following batch query



SELECT CONVERT( VARCHAR(24), GETDATE(), 121)
EXEC cif_query_trans_by_card_Final2 '0060F423F28A6095AD070CEFFD7E81D245D7D0CD7B', '11223345'
SELECT CONVERT( VARCHAR(24), GETDATE(), 121)


But I am getting same value in both timestamp as 2014-12-30 18:09:52.653


Any help will be greatly appreciated.


Thanks in advance.


Aucun commentaire:

Enregistrer un commentaire