Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

SQLDUMPER in SQL SERVER MANAGER
After running many days against a database that contains a few million
records, I see large numbers of the SQLDUMPER.EXE in my task manager.  To
reproduce this, send a query to SQL Server that is large and requires the
full resources of the computer's RAM.  Then open a related application -
specifically Visual Studio 2005.  It will chew into resources that aren't
there and until I killed the Visual Studio 2005 process, my Windows task
manager was literally full of instances of SQLDUMPER.exe.

I read up on this particular object and the articles claimed a bug for this
in SQL Server 2000 was plugged when SP4 arrived on the scene.  The bug state
s
that opening a cursor with the same name as one in another routine required
deallocation prior to use.

Is there a remote possibility that when a query runs in SQL Server 2005,
that it uses resources that are pooled for Visual Studio 2005 to use and whe
n
they collide, SQLDumper.exe is launched?  Can anyone explain the why's and
wherefore's of how this may be occuring?
--
Regards,
Jamie

Report this thread to moderator Post Follow-up to this message
Old Post
thejamie
04-08-06 01:23 AM


Sponsored Links





Last Thread Next Thread
Post New Thread

MS SQL Server archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 09:15 PM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006