Monitoring COMMIT_TABLE Waits

Question

Greetings,

I have a situation where processes start stacking.  It continues to grow until all of the system resources get consumed and the server needs to be reboot.  Below is an example of what happens:

When this happens, the COMITT_TABLE waits increase at approximately the same rate:

I've already set up an alert to notify me when the total database instance reaches a certain threshold.

I'd like to set up another alert that will fire off when only the COMMIT_TABLE reaches a certain level but I can't figure out if that's possible.

Can someone help we out there?

Thanks,

Paul

pebinnh · Answer

Thanks so much for your advise.  I have created this alert as you described.

chenry · Answer

Hello Paul.

This should be fairly straightforward with a 'Total SQL Wait Time for Single Wait' alert under the Wait Time category.

When you create this alert, you can search for that specific wait type 'COMMIT_TABLE', set the interval for 1 hour and the wait time in your case to say 500000 seconds as a min and send the alert to the required group.

pebinnh · Answer

Good Morning,

I've had this post sitting out here for 4 months and no one has replied.  So, I guess that either no one is interested or has an answer that they'd like to share....

Regards,

Paul