Specifying DOP at object level in an OLTP Production DB.

From: FMHabash <fmhabash_at_gmail.com>
Date: Mon, 23 Feb 2009 11:27:12 -0500
Message-ID: <49a2ce5b.1917400a.692e.ffffd500_at_mx.google.com>

Hi all,
Every one in a while, I see some clients who opt to specify a non-default DOP at tables and indexes up to 6. I have not, however, understood why would you want to do that in an OLTP system for quries executing 1000's of times. Is anyone here set DOP as described in an OLTP production DB and why?  Thanks.
Received on Mon Feb 23 2009 - 10:27:12 CST

Original text of this message