QUERY REGARDING ANALYSIS SERVICES | SQL Server Performance Forums

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=’:)‘ />]<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.
&lt; Shameless plug &gt;<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 />&lt; / Shameless plug &gt;<br />[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]<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 />
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |