SSAS Native v .net Provider

Posted by ACALVETT on SQL Blogcasts See other posts from SQL Blogcasts or by ACALVETT
Published on Tue, 30 Nov 2010 19:55:00 GMT Indexed on 2010/12/06 16:58 UTC
Read the original article Hit count: 546

Recently I was investigating why a new server which is in its parallel running phase was taking significantly longer to process the daily data than the server its due to replace. The server has SQL & SSAS installed so the problem was not likely to be in the network transfer as its using shared memory. As i dug around the SQL dmv’s i noticed in sys.dm_exec_connections that the SSAS connection had a packet size of 8000 bytes instead of the usual 4096 bytes and from there i found that the datasource...(read more)

© SQL Blogcasts or respective owner

Related posts about Tips

Related posts about Performance