February 27, 2014 at 11:40 am
I remember there was an article here sometime back on how to baseline/identify appropriate MAXDOP and CTP values in a given environment . Can someone please point me to that? Quick search didn't return much helpful info.
Right now i am just looking at duration to justify? Will that be good enough?
February 27, 2014 at 12:31 pm
Here is an article detailing a method to derive a starting point for CTOP.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 27, 2014 at 12:36 pm
February 27, 2014 at 12:43 pm
SQLRNNR (2/27/2014)
Here is an article detailing a method to derive a starting point for CTOP.
This is a nice article. I've used it several times and got improving results by changing the CTFP (cost threshold for parallelism) value to usually higher values.
Igor Micev,My blog: www.igormicev.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply