Re: Long running queries

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If your load is very heavy with lots of active concurrent users then yes,
this could be a problem. You can scale your IIS server out to multiple
virtual directories/servers to reduce the impact.

Thanks,
Akshai

--
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.


<mkambol@xxxxxxxxx> wrote in message
news:1140128462.091926.169660@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

We're considering using xmla to expose our cube data, but I have a
concern. Queries against our large ROLAP databases could take many
minutes to return. Should we be worried about holding an HTTP
connection open for that long? It seems that if multiple users are
all opening long running queries the resource demand on IIS could be
excessive.



.

Relevant Pages

  • Re: CNAME not working
    ... Trying to alias the intranet site with our new IIS server. ... worked yesterday when the intranet was hosted on our older IIS ...
    (microsoft.public.windows.server.dns)
  • Re: CNAME not working
    ... Trying to alias the intranet site with our new IIS server. ... IIS can host 'sites' based on IP address OR based on ...
    (microsoft.public.windows.server.dns)
  • Re: Can not access SMTP server
    ... Go to a command prompt on the IIS server. ... > regsvr32 smtpsnap.dll ... > Please do not send email directly to this alias. ...
    (microsoft.public.inetserver.iis.smtp_nntp)
  • WPAD.DAT on IIS
    ... anyone knows how do I configure my IIS server ... modify the DNS server to create the alias - ...
    (microsoft.public.isaserver)