This session will take a look at how parallel select into can be scaled to the nth degree in SQL Server, such that all available hardware resources are utilised as fully as possible. Windows Performance Analysis toolkit will be used to ascertain where the pressure points are in order to target efforts in tuning this new feature to the full: including such things as hash partitioning in order to enhance parallel scan performance, reducing pressure on the PFS bit maps, reducing pressure on how the PFS is allocated in memory and the final performnance frontier, reducing the presure on the log cache access spin lock, the thing which ultimately ham strings all workloads that need to be ACID compliant.
Presented by Chris Adkin at SQLBits XIV
MP4 Video HD 543 MB