Didnt knew this discussion so long, good for me though:-). I am also capturing context switches/sec as one of the counters for baseline. Just wanted to let you know.

thanks robert ..the reason why i wanted to clear the logs is so that i can calculate fresh data from the time i have started my testing. And the result...

i tried Apex tool. Does show me the updates and inserts which happened but doest shows me the actuall SQL which did the updates or inserts?

Ok. Thanks. I am trying to do some analysis by changing cost threshold and max dop. I have actually opened another topic here to get some baselines for MAXDOP, if...

so does cost of threshold mean the time taken to complete the query when ran in serial?

No. So no matter if i shrink the file or not back up log file (i.e trn) file would be the same. Probably i should try to take more log...

thanks. Gail but the reason why we are shrinking the logfile is because sometimes the logfile is huge and takes lot of time to copy for logshipping. I think i...

yeah makes sense it wouldnt use COST threshold with DOP 1 (forgot my math...).. Just one last question. Now i am trying to create a baseline and have some good...

thanks Paul and Gail.Based on your statements it makes me believe that irrespective of the value of MAXDOP, Cost threshold will always play a role?

i take it back you are right. Now lets says my logfile size is 1 gb out of that 800mb is unused and 200mb has committed and uncommitted. If i...

thanks...but i am little lost here. Mentioned below few questions which will help me in understanding better

i) if MAXDOP is zero - cost threshold value doesnt matter since sql engine...

Ok, got it now. As per the article if i set MAX DOP to 1 it will not be effective even if i change the cost threshold value but if...

so Gail as per your statement size of log file and size of trn file should be the same? I tested it, my log file is 1 gb and trn...

thanks...what exactly is cost of threshold? I was in an assumption that when you set to 5 it mean sql engine will calculate estimate excution plan and if the query...

Thanks for reply, but from my question i meant to say MAXDOP is 1. Mentioned below is o/p from sp_configure.

max degree of parallelism06411