Cool, thanks for posting back.

37,624 single-use adhoc plans out of 81,031 taking 1.86GB, and prepared plans are not far behind as a percentage...an efficient waste of RAM 😀

I would explore...

For those keeping track at home, here was the change:

Nice one! You should email your fix to Kim. What were your results? Sounds like you're on an instance with a lot of memory.

Welsh Corgi (3/26/2012)

---

opc.three (3/26/2012)

---

I use File System packages and execute them using DTExec from a CmdExec SQL Agent Step Type, not an SSIS Step Type.

I use XML Package Configuration files...

redgate SQL Monitor is one. On the top right of these forum pages you can see it in action. It also gathers historical stats for trending purposes.

If you want to...

Elliott and Koen provided ways for you to run your existing package in 32-bit mode on the server, with no changes, which may be sufficient for your case.

However, if...

Welsh Corgi (3/20/2012)

---

stevefromOZ (3/19/2012)

---

Little known usage of SSMS, but it'll open XML quite happily. Eithe ruse File|Open or simply have SSMS open, go to Windows Explorer and click|drag the file...

What feature of SSIS are you referring to with your comment "the rules within SSIS package" ?

PS This allows me to leave the "SQL Server Integration Services" service disabled on all my servers. I need to install it to gain the binaries necessary to run my...

I use File System packages and execute them using DTExec from a CmdExec SQL Agent Step Type, not an SSIS Step Type.

I use XML Package Configuration files (.dtsConfig) for all...

Indirectly, a bloated proc cache from tons of ad hoc queries generating single-use plans can contribute to memory pressure since the proc cache can grow largely unchecked. Since you're on...

SQL Server 2005: Partitioned Table and Index Concepts

SQL Server 2008 R2: Partitioned Table and Index Concepts

Are you in the correct database when you run sp_rename?

It's a bug. Apply SQL Server 2005 SP1 or later.

Sounds like a .NET question, more than an SQL question. You may want to try posting to the .NET Development Forum on MSDN.