Hello everyone - we are having a strange performance issue after upgrading from SQL 2000 32x Std to SQL 2005 64x Std SP2. Our ERP system is not making use of store procedures or any form of T-SQL batches, instead it synchronously sends a bunch of SQL commands. For example, to ship all lines on a sales order it sends a total of ~1000 SQL instructions and waits for each to finish before moving forward with the next. Poor design you would say, huh? Anyway we have to live with it for the time being b/c we can not modify source code. Before the upgrade this particular transaction and many similar ones in nature, were only taking 1-2 seconds. However after the upgrade it is now taking over 2-3 minutes!!! Nothing has changed in terms of network, personal computers or database. Only that we upgraded the OS to Windows 2003 64x Enterprise and loaded SQL 2005 64x Std w/ SP2. We have also deployed Windows 2003 32x server w/ SQL 2005 32x on another server to make sure this has nothing to do with hardware and tested ERP against a copy of database there with same poor performance result. Then we captured all SQL commands via profiler and encapsulated them to a dummy stored procedure and ran same statements, and then it took only 2 seconds... Any ideas would be appreciated, thanks.