RE: SQLXML problems

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

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 10:01:12 GMT

Hi Daryn,

Thank you for posting in the community!

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you are selecting data using SQLXML.
When more than 7000 records are hit, an Access Denied exception is thrown,
and the server's performance decreases. However, the CPU usage is about 0%.
If there is any misunderstanding, please feel free to let me know.

This issue seems to be very complicated. There might be many reason that
caused this. Here I listed some of them.

1. Since it happen after about 7000 select operation, there might be some
abnormal memory growth/leak problem. However, from the code, we cannot find
any memory leaks. It might be in other code blocks.

2. The first sign is "Access Denied". If it is an SQL server's error
message, we can tell them to trace on SQL side or some log to see where it
reports. Generally we can use SQL Profiler to do the trace. Start SQL
Profiler and run a new trace. In the trace log, we can see when the error
happens, what credential is it using, to connect to SQL server.

3. I'd like to know how does the code you have pasted run in the thread.
Are you running it in a "for" loop or something else?

Please provide us with more information, so that we can make furthing
debugging. Thanks for your cooperation.

If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Quantcast