Re: Slow Data Retrieval - ASP (Windows 2003) and Analysis Services SP3
From: PD (pdaniel_at_commonwealth.com)
Date: 01/05/05
- Next message: mkambol_at_yahoo.com: "Determining memory used by AS"
- Previous message: Milind: "Group total in MDX"
- In reply to: PD: "Slow Data Retrieval - ASP (Windows 2003) and Analysis Services SP3"
- Next in thread: Helma Schapendonk-Maas via SQLMonster.com: "Re: Slow Data Retrieval - ASP (Windows 2003) and Analysis Services SP3"
- Messages sorted by: [ date ] [ thread ]
Date: 5 Jan 2005 10:24:13 -0800
PD wrote:
> We just moved our production web site to Windows 2003. We have asp
> pages that access OLAP cubes via the 'cn.Open "provider=MSOLAP.2;Data
>
> Source=dbname;user id=sid;password=pw;Initial Catalog=Balanced
>
> Scorecard;SSPI=anonymous"' provider code. We are running Analysis
> Services SP3. This works fine under our Windows 2000 environment.
Now,
> it takes approx. 45 seconds for MDX statements to return data. Any
> thoughts/suggestions on where I can look to see what might cause
this?
> The data does return back succesfully after the 45 seconds. The SQL
> Server box where Analysis Services is installed did not change.
> As always, thanks!
> PD
I was able to narrow down the code that is causing the delay..
set cn = Server.CreateObject ("ADODB.Connection")
cn.Open "provider=MSOLAP.2;Data Source=dbname;user
id=sid;password=pw;Initial Catalog=Balanced Scorecard;SSPI=anonymous"
set cs = Server.CreateObject ("ADOMD.Cellset")
''DELAY HAPPENS ON THE FOLLOWING LINE OF CODE
cs.ActiveConnection = cn
It takes approx. 5 seconds per connection on the Windwos 2003 box and
less than a second on the Windows 2000 box. I could see if it was a
rights/privilege/IIS issue then I would not be able to get a
connection, but since I am able to get a connection (after the 5
seconds), I'm not sure where to look next. I'm running MDAC 2.8,
Analysis Services sp3, Pivot Table 8.0.1.94.
- Next message: mkambol_at_yahoo.com: "Determining memory used by AS"
- Previous message: Milind: "Group total in MDX"
- In reply to: PD: "Slow Data Retrieval - ASP (Windows 2003) and Analysis Services SP3"
- Next in thread: Helma Schapendonk-Maas via SQLMonster.com: "Re: Slow Data Retrieval - ASP (Windows 2003) and Analysis Services SP3"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
