Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
karl2006
Starting Member
4 Posts |
 Posted - 2008-03-02 : 23:09:38
|
| Dear all,I've found some problem using analysis service in our environment:server specification:Windows 2003 R2 Standard Ed SP1RAM 1,75GBSQL Server 2000 SP3aSQL Analysis Services SP3aUser has some problem when accessing data using Analysis service. They are accessing through HTTP (because they are using Windows XP Home and cannot join domain). They always encounter slow response ASP page IIS6 so the data displayed is not full and sometimes their excel is not responsed (they are using pivot table in excel). FYI, this problem has not happen in previous windows (Windows 2000 Server).Please advice. Any help and suggestion is very appreciated.Best regards,Karel |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-02 : 23:33:46
|
| Did you change network settings? |
 |
|
|
karl2006
Starting Member
4 Posts |
Posted - 2008-03-03 : 02:31:35
|
| No, the network setting was not changed. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-03 : 23:18:08
|
| How about resource usage on the server? |
|
|
|
karl2006
Starting Member
4 Posts |
Posted - 2008-03-06 : 05:33:31
|
| Hi,Sorry for delayed respons. No, the usage is in normal condition. Maybe, do you have any suggestion about the setting?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-06 : 23:05:56
|
| I'll double check network bandwidth in this case. |
|
|
|
karl2006
Starting Member
4 Posts |
Posted - 2008-03-14 : 04:36:44
|
| Hi,Ok, thanks for your suggestion. |
|
|
|
|
|
|
Slow Response ASP Page IIS6