Re: IIS performance problem and SQLXML.
From: pignouve (pignouve.18rec2_at_mail.mcse.ms)
Date: 07/02/04
- Next message: Peter Newman: "newbie to XML"
- Previous message: Phil Jenson: "Re: SQLXML Bulk Load Triggers"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 2 Jul 2004 04:17:52 -0500
Hi !
I got exactly the same problem : i'm using SQL Server XML Support for
IIS and when i use a template to query my DB, the process sqlserver and
inetinfo eats up memory and don't release it.
Does anyone have an idea ?
Thanks in advance
marina wrote:
> *Hi
>
> I have an application which inserts data into a database
> using IIS and SQLXML .
>
> Scenary
>
> IIS 6.0
> SQLSERVER 2000 using a memory size fixed to 512MB.
> Windows server 2003 with 2GB of memory
> SQLXML 3.0 sp1
> This server has only this application.
>
>
> The database in working perfect , but when the IIS
> receives a lot of simultaneous conections ( 80 per second
> of average, we have seen in the log file 200 request per
> second received in some cases. ) the server is using
> 100% of CPU ( inetinfo.exe process ) and the response
> time increases in an alarming way.
>
> The aplication has only 3 templates without XSLT but only
> one of then is used continuosly.
> The sqlxml caching is enabled by default ( so It has 31
> templatecaching size ).
>
> The template has this query:
> <sql:query client-side-xml="0">
> exec almacenaDatos
> @Emp,@Cen,@Fec,@User,@Tx,@Desc,@InCopy,@OutCopy
> </sql:query>
> The params are received by post.
>
>
> Can anyone give me any clue?
>
> Thanks in advance.
> Marina *
-- pignouve ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message285879.html
- Next message: Peter Newman: "newbie to XML"
- Previous message: Phil Jenson: "Re: SQLXML Bulk Load Triggers"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
