Tim... wrote:You've kind-of missed the point of the original post.
I don't really think I did -- but I was apparently not clear enough. My point was that when using parallelism, DBAs must always
take into account that the operation will use more database resources. If the server the database is on has those resources to spare, then parallelism makes better use of what you have (unused CPU cycles, memory and I/O bandwidth benefit nobody). If the server is running low on resources, parallelism can be harmful.
I understand that your reply was focused strictly on setting the table DOP vs
using a query. I wasn't trying to imply yours was wrong. Mine was simply referring to the decision on parallelizing operations in general. The OPs first sentence was asking if there was a disadvantage in setting the parallelism at the table level. There certainly *is* if his server is short on resources and parallelizing queries against that table will cause shortages elsewhere.