xpweb90.exe

1 Mar 2007 11:24 AM

gurbao

Hi,

we have sql server 2005 EE SP1 in a cluster with 3 instances.

>From time to time I see that one of these instances are using about

50% CPU and when profiling I found a couple of

EXECUTE [web_20070301031622647568] -- seems to have a
timestamppattern in the number

using more than 4 000 000 CPU ms and more than 185 000 000 reads !!

The profiler reports XPWEB90.DLL as the applicationname. It is invoked
by the sql service user and having the same clientprocessid as the sql
server itself (naturally).

Anyone knows what this is?
What is this dll doing and what is invoking it?

TIA,

1 Mar 2007 11:37 AM

gurbao

Show quote

On Mar 1, 12:24 pm, "gurbao" <aud***@gmail.com> wrote:
> Hi,
>
> we have sql server 2005 EE SP1 in a cluster with 3 instances.>From time to time I see that one of these instances are using about
>
> 50% CPU and when profiling I found a couple of
>
> EXECUTE[web_20070301031622647568] -- seems to have a
> timestamppattern in the number
>
> using more than 4 000 000 CPU ms and more than 185 000 000 reads !!
>
> The profiler reports XPWEB90.DLL as the applicationname. It is invoked
> by the sql service user and having the same clientprocessid as the sql
> server itself (naturally).
>
> Anyone knows what this is?
> What is this dll doing and what is invoking it?
>
> TIA,

Ok,

did some more research and found that this dll is actually the SQL Web
Assistant Extended Procedures DLL.

We have migrated some reports from sql 2000 using this proc. I will
have closer look at what was run at that time.
These used to run just fine before migration.
Anything particular I should be looking for debugging this?

TIA,

22 Apr 2007 6:24 PM

ramin

i want xpweb90.exe
thank you From http://www.developmentnow.com/g/118_2007_3_0_0_939105/xpweb90-exe.htm Posted via DevelopmentNow.com Groups http://www.developmentnow.com

22 Apr 2007 7:23 PM

Tibor Karaszi

What is xpweb90.exe? The only such I know of is xpweb90.dll, which is a part of your SQL Server 2005
installation.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

Show quote

"ramin" <rami***@hotmail.com> wrote in message
news:1d11219d-19d4-42b5-aa5f-8f55429172ee@developmentnow.com...
> i want xpweb90.exe
> thank you
>
> From http://www.developmentnow.com/g/118_2007_3_0_0_939105/xpweb90-exe.htm
>
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com

24 Nov 2007 6:52 PM

Francisco Gil

I'm getting this message

Could not load the DLL xpweb90.dll, or one of the DLLs it references

When I try to use sp_makewebtask

From http://search.yahoo.com/search;_ylt=A0oGklUEcUhHH.wAUW9XNyoA?p=xpweb90.dll&y=Search&fr=yfp-t-501&ei=UTF-8 Posted via DevelopmentNow.com Groups http://www.developmentnow.com