Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sunny Parallel Processing RE: Parallel Processing

  • October 12, 2009 at 9:11 am

    #1064784

    Simon,

    I see that your discussion post mentions multiple servers...

    But in the article in question, http://www.sqlservercentral.com/articles/Locking/67952/ only seems to be talking about one server.

    So what does the article's technique have that MS SQL Server doesn't out of the box?

    Thanks!

    Charles Wilt

    Simon Facer (10/12/2009)

    [p]Charles, I think you missed the point ... [/p]

    SQL will SMP parallel-process out of the box, automatically generating query plans to take advantage of multiple available processors as appropriate. The article was about manually setting up parallel processing tasks. In the example I gave, the parallel tasks are querying multiple independant unrelated servers simultaneously; this is not an SMP task as you were referring to.