Excessive chatiness in Linked Server Query to Analysis Services

hi,

i have set linked server point @ ssas instance exposed on http via msmdpump.dll.

i running simple query , like...

select * openquery(mylinkedserver,'select [catalog_name] $system.dbschema_catalogs')

however, results in 25 requests , responses. first 11 seem extraneous chit chat, request 12 seems test whether query supported (execution mode = prepare), request 14 - 25 seems repeat whole process on again, time request 24 returning results.

so question is, how reduce preamble chit chat , , duplication. same query run clr equivalent (using adomdclient  takes 2) , there must way reduce chat somewhere near level?

i happy supply more detail required.

regards,

richard

hi richard,

thanks post. looking issue , give update possible.

thank understanding , support.

if have feedback on our support, please click here.

best regards,

---

elvis long
technet community support

SQL Server  >  SQL Server Analysis Services