All Forums Viewpoint
sarthz 4 posts Joined 03/13
16 Jul 2013
Spool alert setup

Is it possible to set up an alert when peak spool/spool for a user goes beyond a certain value? P.S. Viewpoint version i want to set up it on is 14.01
(I read in these forums this is possible on 14.10 onwards) But is there a workaround for 14.01?
For example, if I want to abort an unimportant query because it is hampering the performance of other SAS queries causing spool out issues.

stever 149 posts Joined 08/09
16 Jul 2013

The spool for a session has always been visible in the Query Monitor and other Query portlets, but the alert was added in Viewpoint 14.10 as you indicated.  There's no workaround to get this functionality in 14.01.  I would suggest you upgrade to 14.10 if this is a feature in which you're interested.

sarthz 4 posts Joined 03/13
16 Jul 2013

Thanks Stever!
But is it possible to set up a spool threshold filter in TDWM?

stever 149 posts Joined 08/09
17 Jul 2013

Yes, there are exceptions for Spool Rows and Spool Usage (in bytes) in TDWM.

sarthz 4 posts Joined 03/13
17 Jul 2013

@Steve
What do you mean by Spool Rows?

stever 149 posts Joined 08/09
18 Jul 2013

Spool Rows is the count of the rows put into spool for a query.  Spool Usage is the amount of space that these rows consume.

sarthz 4 posts Joined 03/13
18 Jul 2013

Oh! I see. Thanks Steve, I will see what I can do.

You must sign in to leave a comment.