This script consists of 9 stored procedures intended to make profiling (timing) of pieces of code in stored procedures and triggers a breeze. Automatically adds code to stored procedures and triggers to save elapsed time, CPU time and Physical IO. Stored procedures are provided to initialize and terminate profiling in a database, to setup, restore, enable and disable stored procedures and triggers for profiling, to reset profiling data, and to report on the gathered profiling data. Also included is a stored procedure that prints elaborate help on how to use this system. The zip includes a readme-file with information on installing this system.
Author: Jeremy van Dijk
Disclaimer: We hope that the information on these script pages is
valuable to you. Your use of the information contained in these pages,
however, is at your sole risk. All information on these pages is provided
"as -is", without any warranty, whether express or implied, of its accuracy,
completeness, or fitness for a particular purpose...
Back to Database Journal Home