As you all might have noticed in the posts of the past few weeks we’ve been migrating from SQL Server 2000 to 2005. Well I’m happy to say that were almost done. And that after only two weeks.
A you may have read in the day after post the physical migration went al right. It was after migration we encountered some problems. I’ll give a short list of all the problems:
- When running multiple SSIS packages at once the server breaks, our packages that take a bit longer fail reporting that InnerPackage.dtsx is locked by the OS.
- The SQL server likes to allocate more memory in the physical memory the actually present, causing it to crash (can be fixed by setting a memory limit)
I’ve reduced the first problem by reducing the amount off time needed to execute the single SSIS packages.