SSAS – Synchronisation performance

Posted by ACALVETT on SQL Blogcasts See other posts from SQL Blogcasts or by ACALVETT
Published on Wed, 07 Apr 2010 23:15:00 GMT Indexed on 2010/04/07 23:43 UTC
Read the original article Hit count: 900

I’ve always thought of SSAS synchronisation as a clever file mirroring utility built into SSAS and i have never considered the technology as bringing any performance gains to the table. So, its a good job I like to revisit areas…. :) I decided to compare the performance of robocopy and SSAS Synchronisation between 2 Windows 2003 servers running SSAS 2008 SP1 CU7 with 1gb network links. For the robocopy of the data directory i used the SQLCat Robocopy Script . The results are shown below. SSAS Sync...(read more)

© SQL Blogcasts or respective owner

Related posts about Performance

Related posts about Analysis Services