PROCEDURE spLogSqlPerformance

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.

Input and output parameters

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

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