The Profiling Task gets stuck
-
Hi:
I'm trying to assess the data inside a SQL Server 2005 database. I'm using the profiling task of the SSIS 2008.
I'm selecting all the profile request in the profile generation, and when I run the task it progresses until 10% and then gets stuck. The CPU usage doesn't exceed 70%. The Database contains about 125 tables with a lot of instances.
The SSIS is running under a virtual machine with a Windows XP, 2 processors and 1Gb of RAM.
Do I need a powerful system, what could be the problem?
Greatings
Paul Hernández
Paul Hernández -
paul.pauldj54 (11/27/2009)
Hi:I'm trying to assess the data inside a SQL Server 2005 database. I'm using the profiling task of the SSIS 2008.
I'm selecting all the profile request in the profile generation, and when I run the task it progresses until 10% and then gets stuck. The CPU usage doesn't exceed 70%. The Database contains about 125 tables with a lot of instances.
The SSIS is running under a virtual machine with a Windows XP, 2 processors and 1Gb of RAM.
Do I need a powerful system, what could be the problem?
Greatings
Paul Hernández
Hi Paul,
When your process gets stuck use the SSMS to find out what are the locked objects in SQL Server. Probably there are multiple processes trying to access same objects and you have dead-lock somewhere.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply