PeopleSoft-on-SQL-2008.docx

<div>
<div class="content wysiwyg-content">
We were on PeopleSoft 8.8 / Oracle 10g and have migrated to PeopleSoft 9.1 and a SQL Server 2008 R2 back end.<br />
<br />
In the past on Oracle 10g we could run multiple AP processes at the same time for different companies without incident. &nbsp; Now on SQL Server 2008 R2, the first process will hold up the second process until the first process is complete even though the process are updating for different key values. &nbsp; <br />
<br />
Does SQL Server really lock the entire table or is it a configuration issue?<br />

</div>
</div>


We were on PeopleSoft 8.8 / Oracle 10g and have migrated to PeopleSoft 9.1 and a SQL Server 2008 R2 back end.

In the past on Oracle 10g we could run multiple AP processes at the same time for different companies without incident.   Now on SQL Server 2008 R2, the first process will hold up the second process until the first process is complete even though the process are updating for different key values.   

Does SQL Server really lock the entire table or is it a configuration issue?


SQL Server 2008 R2 versus Oracle 10g Locking Issue

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.