Batch Processing (OLTP) - Background or Asynchronous

Batch Processing (OLTP)---a Technical Reference Guide for Designing Mission-Critical OLTP Solutions

Source: SQL Server 2012



Batch (sometimes also called Background or Asynchronous):
--------------------------------------------------------

Batch (sometimes also called Background or Asynchronous) processing is generally characterized by the absence of user interactivity.
Few systems are purely transactional or batch-oriented; even systems that are designed primarily as batch systems may have an online component.
For example:


Most month-end or year-end application processing is performed in batches.

Utility (electric, gas) bills are generally produced via batch processing for mailing to clients, while current month usage computation for review by the
online user is likely to be computed independently online and not via batch processing, even though most of the application logic may be very similar in
batch and online processing.


Best Practices:

Batch processing may require scheduling help. The SQL Server 2008 Books Online article Implementing Jobs1 describes how SQL Server Agent can be used for
scheduling jobs.


...MORE INFO IS THIER

Consider using partitioned tables for large extraction, transformation, and load (ETL) operations. Loading data to an empty partition, creating the indexes,
and switching the partition into the table can be faster than normal insert operations by orders of magnitude. For more information, see the following



SQL 2008 Series: SQL Partitions / partitioning