SSIS, BIDS & Memory Use

FAQ

Profile

SSIS, BIDS & Memory Use

Database Forums (Home) -> Data Warehouse

Next: DBA / sysadmin needed - UK

Author

Message

Christian Loris

External

Since: Jan 10, 2008
Posts: 1

(Msg. 1) Posted: Thu Jan 10, 2008 2:51 pm Post subject: SSIS, BIDS & Memory Use Archived from groups: microsoft>public>sqlserver>datawarehouse (more info?)

I have been having an issue where I run a small HR Headcount Fact Table build in SSIS for 50+ iterations. I slowly run out of memory. It appears that BIDS is not releasing it. There is very minor custom code and all of it is clean and calls dispose, etc. Are there any known issues with SSIS/BIDS not releasing memory? When my master package finishes runing, it stops with success but doesnot free memory. It only relinquishes the 1GB of memory when I stop the debugger. Thoughts? Help? -- Christian Loris http://www.implementsivillage.net >> Stay informed about: SSIS, BIDS & Memory Use

Display posts from previous:

Related Topics:

BIDS Variable Window Disappeared - I am experiencing a weird problem with SSIS development in BIDS... When I click "View --> Other Windows --> Variables", the window doesn't show up. Has anyone else had this issue? If so did you solve it, and how? Thanks!

o Memory error: Sept CTP - help (cross-post) - I'm an Business Intelligence student and trying to do a cube assignment using September CTP of SQL 2005. When I try to browse my deployed cube by dragging any field from the cube attribute list into the data pane I get the following error: The query...

SQL 2005 Analysis Memory requirement - Hello everyone, We are planning to purchase hardware for Analysis Server. I want to see what configuration everyone is using for the Analysis Server. How much RAM on your server, how many processors, size of the cub, Server edition, etc... Someone....

in sql server is it possible to get the amount of memory u.. - in sql server is it possible to get the amount of memory used by a stored procedure? e.g. memory usage statistics per stored procedure?

How to tell sql server the maximum size my temptable will .. - How to tell sql server the maximum size my temptable will grow so that it does at most 1 memory allocation?

	Database Forums (Home) -> Data Warehouse	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum