All Forums Tools
Darin 13 posts Joined 09/05
31 Aug 2010
Parallel Transporter uses more spool than other types of sessions.

Any idea why TPT is using more spool than the same query in other tools such a SQL Assistiant?

ratchetandclank 49 posts Joined 01/08
31 Aug 2010

The question is not very clear. What is the query you submitted ? Which operator are you using in your TPT script ?

If you are using update operator, then it will use more spool space because the protocols between SQLA and Update operator are different.

You must sign in to leave a comment.