Skip to Content
2
Jun 15, 2015 at 05:00 PM

PLaying with Max Degree of Parallelism Option in SQL Server 2012 and higer

288 Views


So after reading that great article, I was eager to try this out.

I so happen to have a physical intel server 16 CPU's.

So I ran a test of a DBCHECK at parallelism 1. Took 4:20 hours.

Changed parallelism to 2, ran DBCHECK again, took 2:22 Hours.

Aprx 45% increase in time.

So Then I re-ran the same test again and the times came in within seconds of those above.

Now, I'm looking for another test, something DB extensive and that is relatively the same test each time.

I'm wondering if an SGEN would work?

Anyone have a suggestion of an SAP job I would try to benchmark and play with this?