IIS performance problem and SQLXML.

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<!-- ~MESSAGE_AFTER~ -->

"marina" <anonymous DeleteThis @discussions.microsoft.com> wrote in message
news:086301c3db4c$c6b53e30$a401280a@phx.gbl...
 > 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?

Add more CPU's to your system!
from 80 to 200 requests a second on a single OS that processes XML (needs a
lot of CPU!) is not bad at all.


Regards,


Egbert
--
compatible web farm Session replacement for Asp and Asp.Net
<a style='text-decoration: underline;' href="http://www.nieropwebconsult.nl/asp_session_manager.htm" target="_blank">http://www.nieropwebconsult.nl/asp_session_manager.htm</a>


 > Thanks in advance.
 > Marina<!-- ~MESSAGE_AFTER~ -->