all-

I tried out SQLXML 3.0, and IIS with SQL Server 2000, and was amazed to find out that I could return a search transformed from an XSL stylesheet into with almost no increase in the memory the processes were using.
I ran IIS with SQL client tools installed on one box and set up a SQLXML 3.0 directory on the SQL server pointing to that server.
I watched inetinfo.exe on the web server and sqlserver.exe on the db server.

The same search on an .aspx page swelled aspnet_we.exe to 69+ megs.

The same search on the existing ASP page with VB COM data access threw DLLHOST.exe into a grand mal and sent IIS down with it.

Sure there are a million other possible explanations for these phenomena, but the same hour of coding resulted in three very different results.

My question is this: is the huge amount of memory SQL server is using hiding what is going on? If the answer is yes, are there any statistics on performance load with heavy use of SQLXML for data retrieval?

I need more evaluation information than my data collection has provided, but any experiences related to SQLXML use would be greatly appreciated, on or off topic.

thanks,
grant babb
L-EET Web Services
http://www.l-eet.com/