please do not cross-post

http://www.sqlservercentral.com/Forums/Topic568621-360-1.aspx

Sorry, I did not read your post very clearly, I though your prod server time was in seconds.

Do you have access to PerfMon on the production server? It would...

I have to agree with Grant, the design is flawed and you should be using a surrogate key if what you are currently using for a primary key field is...

I would start by logging all of the events in the package to see exactly where it is getting "stuck".

The hardware differences are significant and could easily be the difference....

Ninja's - the answer is no.

That is clearly an example of multiplexing - which is explicitly addresed in the licensing and is not allowed. Each client connecting would need...

Ok, msanchez, since you are clearly getting upset, I am going to pour some gas on the fire.

The last definition you posted:

[font="Courier New"]"a logical collection of information, gathered from many...

- The paging file is too small for this operation to complete -

You have a memory pressure issue. Break out PerfMon and log the memory usage for all...

Unfortuantely, there is no upgrade path from a server/cal license scheme to a per-processor scheme as far as money. So, if you start out going cheap, you will have...

If you can depend on a set number of devices connecting, and the number is not really high, a server / CAL approach is usually cheaper.

However, since you have an...

What are the errors you are getting?

Yes, the procedure cache is in memory so it is tied to the active node.

Sometimes Steve forgets how to post a hyperlink...

http://www.red-gate.com/products/sql_backup/offers/exceptional_dba_awards.htm?utm_source=dba_awards&utm_medium=button&utm_content=being_exceptional&utm_campaign=sqlbackup

It MUST be installed, I am not sure if it has to be running.

MSSQL marks a process as "suspended" when the process has made a request to a non-SQL process or resource and is awaiting a response. This happens a lot when...

You should at least properly prepare your SQL statements and use parameterized queries. SQL injection is a common security problem and you have made it easily possible with your...