Management FAQ Experiencing delay when connecting to SSAS using SQL Server Management Studio?
| Experiencing delay when connecting to SSAS using SQL Server Management Studio? |
| Written by Vidas Matelis | |||
| Wednesday, 18 April 2007 11:40 | |||
|
Q: When I use SQL Server Management Studio to connect to AS (on some servers) I have to wait a couple of minutes before it is established. Do you know why and how can we fix that? Dejan www.tsql.ca A: This is known issue with SSAS 2005 that was fixed in SP2. This was especially visible on servers with multiple databases and many partitions. In pre SP2 environment SSAS would enumerate all objects during connection. In SP2 this changed and enumeration of objects happens on per need basis. On our servers in pre SP2 environment we waited up to 10min for connection to be established. After SP2 this connection happens instantly. If you cannot upgrade to SP2, you should consider reducing number of databases on SSAS server. Also on SP2 you could experience some delay when you connect to SSAS first time after SSAS service started.
|
Most read
- How to install Adventure Works SQL DW and Analysis Services 2005 sample database and project
- MDX-How can I get Last (Previous) Year to Date (YTD) values?
- Analysis Services 2005 error: Errors in the metadata manager. The attribute with ID of ., Name of . refer
- MDX-How do you format or round KPI expression value?
- MDX-How do you calculate monthly average of one year, optionally including empty months?
Top Rated
- How to install Adventure Works SQL DW and Analysis Services 2005 sample database and project
- Analysis Services 2005 XMLA script to add/drop existing partition aggregate
- Why In Reporting Services MDX query disappears after leaving "Data" tab.
- When accessing calculation tab in BIDS I am getting error Unexpected error occurred
- In an MDX query how can I get the top 3 sales years based on the order quantity?
- What TCP port SQL Server Analysis Services 2005 uses
- How to calculate YTD monthly average and compare it over several years for the same selected month
- Analysis Services 2005 error: Errors in the metadata manager. The attribute with ID of ., Name of . refer
