In the SQL Server database, how can I view the execution time of SQL statements? This article will introduce you to the query method for your reference.
The following is a simple SQL statement execution time query method in SQL Server. It is calculated based on the time difference between the query time and the query time:
Declare @ begin_date datetime
Declare @ end_date datetime
Select @ begin_date = getdate ()
<Write your statement here...>
Select @ end_date = getdate ()
Select datediff (MS, @ begin_date, @ end_date) as 'time/millisecond'
2: The following method is comprehensive. The steps taken when each statement is executed are returned as a row set and are displayed in the form of a hierarchy tree.
Set statistics profile on
Set statistics Io on
Set statistics time on
Go
<Write your statement here...>
Go
Set statistics profile off
Set statistics Io off
Set statistics time off