i am trying to connect analysis services on remote computer (10/100 M) i have time lapse of 20 sec while setting up the connection. PL SUGGEST SOLUTION TO REDUCE THE CONNECTION TIME.
Books online would give you more information about information on AS. http://msdn.microsoft.com/library/en-us/dnsql2k/html/sql2k_connpooling.asp for information. Is it timing out or failing to process? Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
no it is successfully establishing the connection but takes time quote:Originally posted by satya Books online would give you more information about information on AS. http://msdn.microsoft.com/library/en-us/dnsql2k/html/sql2k_connpooling.asp for information. Is it timing out or failing to process? Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Then check the netbios settings and lmhosts and ensure no issues on network. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Just flipped through my link library. Maybe there is something useful in here: http://support.microsoft.com/default.aspx?scid=kb;EN-US;827422 http://support.microsoft.com/default.aspx?scid=kb;EN-US;324040 http://support.microsoft.com/default.aspx?scid=kb;EN-US;841178 http://support.microsoft.com/default.aspx?scid=kb;en-us;815486 http://support.microsoft.com/default.aspx?scid=kb;en-us;826310 -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
I'm sure Frank's links will come handy to investigate further. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Hopefully. To be honest, I don't deal with AS here, but I do collect KB links, so who knows....[<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
Cool, whatsoever it may be the basic connection concept for a OLTP or OLAP SQL Servers will be the same and referred articles deals with the issue. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
< Shameless plug ><br />At the moment there are 1324 links in my library. Almost all are in english. <br /<a target="_blank" href=http://www.insidesql.de/component/option>http://www.insidesql.de/component/option</a>,com_weblinks/Itemid,49/<br />< / Shameless plug ><br />[<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
[8D] may be its good idea for you to convert them to German .... Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
No, not really. The German translations of KB articles is poor, to say the least. To get accurate informations, I stick with the english originals. [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />