SQL Server Performance Forum – Threads Archive

QUERY REGARDING ANALYSIS SERVICES

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=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

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 > At the moment there are 1324 links in my library. Almost all are in english. http://www.insidesql.de/component/option</a>,com_weblinks/Itemid,49/ < / Shameless plug > [<img src=’/community/emoticons/emotion-2.gif’ alt=’

[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=’

]]>