All Forums Database
DBAdude 2 posts Joined 06/06
29 Feb 2012
Spoolusage from DBQL for failed SQLs

When a user SQL fails with 2646 error(No more spool space error), Which is the best place to look at the requested spool space by the user for that transaction?

Queried DBQLogtbl, but that doesnt seem to give the exact requested spoolusage for failed SQLs.

Any thoughts?

You must sign in to leave a comment.