jim 29109 (12/27/2012)
whether MaxDop could make a difference to Commits?
i dont think maxdop can affect the commit although it can speedup the queries at the cost of CPU. have you tried to test the database query through management studio directly and ask the DBA to set the trace and see whats baking the query
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)