Regresar
-
Título
How to obtain the duration time of a SQL execution in Spotlight? -
Descripción
How to obtain the duration time of a SQL execution in Spotlight? -
Resolución
Without using the SPID of SQL statement:1. Open SQL Activity | Query Execution Statistics tab, locate the Last Duration and Last Execution Time of each SQL Statement (this screen does not include the SPID field)Using the SPID of SQL statement:1. Open SQL Activity | Sessions page, locate the SPID row and right click on the Plan Handle column of that row2. Select Copy to Clipboard option and then Copy Selected Cell option to copy the plan handle3. Open the Query Execution Statistics tab and right-click anywhere on the grid, select the Find option4. Paste the copied plan handle to find it in this screen5. Locate the Last Duration and Last Execution Time columns for this SQL