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

nametypelengthinoutpnum
@startTimedatetime8input5
@endTimedatetime8input7
@busyTimebigint8input6
@rowsbigint8input8
@webservervarchar64input1
@winnamevarchar64input2
@clientIPvarchar16input3
@accessvarchar64input4
@errorMsgvarchar1024input9