Procedure to log success (or failure) of a SQL query to the performance log. |
The caller needs to specify the time the query was started, the number of seconds (bigint) that the CPU was busy during the query execution, the time the query ended, the number of rows the query returned, and an error message if applicable. The time fields can be 0 if there is an error. EXEC dbo.spLogSQLPerformance('skyserver.sdss.org','',,'',getutcdate()) See also spLogSqlStatement. |
name | type | length | inout | pnum |
@startTime | datetime | 8 | input | 5 |
@endTime | datetime | 8 | input | 7 |
@busyTime | bigint | 8 | input | 6 |
@rows | bigint | 8 | input | 8 |
@webserver | varchar | 64 | input | 1 |
@winname | varchar | 64 | input | 2 |
@clientIP | varchar | 16 | input | 3 |
@access | varchar | 64 | input | 4 |
@errorMsg | varchar | 1024 | input | 9 |