vendredi 19 décembre 2014

Efficient settings for linked server to SSAS database


We are using OPENQUERY scripts to run MDX from sql-server. We're experiencing efficiency issues when we first run these queries each morning.


The linked server objects which link to our SSAS databases are set as follows.


Are these the most efficient setting for this context?


enter image description here





Aucun commentaire:

Enregistrer un commentaire