Efficent vs In-efficent processing

[BruceD Lindberg]

I have been a DBA for a while and watch/record commits that our 3 main databases have. There has been occasions where the business expands in some way so some new code is developed and when its its implimented the commits number jumps, like Ten Times what it was.

Is there any documentation on how to analyze performance numbers and relate poor or heavy performance back to specific programs?

 

[Casper]

Hi Bruce,

Did you already had a look at the profiler? ($DLC\src\samples\profiler).
Or for more general statistics: use of -yx parameter.

Regards,

Casper.

 

[BruceD Lindberg]

I haven't had a chance to look into the profiler yet, but it saw it way back in the DLC directories.