SAP Knowledge Base Article - Preview

1728171 - Slow performance or job failure when reading from and writing to the same Microsoft SQL Server table - Data Services

Symptom

  • Slow performance
  • Intermittent job failures
  • SQL Server table is being locked
  • A SELECT statement on a SQL Server table is blocking an UPDATE statement


Read more...

Environment

  • Data Services
  • Microsoft SQL Server

Product

SAP BusinessObjects Business Intelligence, Edge edition 4.0, version with data integration

Keywords

block, locking, MSSS, SQLServer, DF, data, flow, reader, loader , KBA , EIM-DS , Data Services , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.