Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jasondini
Starting Member
1 Post |
 Posted - 2004-12-06 : 02:11:33
|
| I'm hoping somebody will be able to give me some help with this one. I am running a stored procedure in query analyser that makes a call to a dll that in turn loads quite a couple of files (into the sql process/memory space I presume). We have added code to the dll to write to the event log at various intervals. When run on my small server with XP and 500 mb of memory this runs fine. However when I run this on our big Xeon dual-processor boxes (Windows 2000 with more than 2 gb of memory) there are problems. Both databases are the same size. The only difference really appears to be the operating systems and the processors. The problem is still there when I try limit sql to use only 1 processor. I have messed around with virtual memory, changing page size, and that doesn't seem to make any difference. If anybody has any experince with a problem of this nature with Xeons and Windows 2000 I would be happy to hear about your experiences and problems you managed to sort out. Thank you. |
|
|
|
|
|
SQL 2000 sp call to dll runs out of memory