This project is read-only.

Documents

 
SwissPASSChapter.png
SQL Parallel Boost increases the execution performance for
high volume data modification operations by up to factor 10 (!).

Product Presentation: Download/View PDF Presentation as presented at SQLPass Zurich (Switzerland).

Manual/Documentation: Download/View PDF Product Manual.
Note: the documentation covers the full functionality of the Enterprise Edition.
The free Community Edition is limited in some functionalities - see entry page (Home).

Solution Architecture

ParallelBoost_ObjectArchitectureDetail.png

Installation and Operations

Installation
(The backup file is compatible to SQL 2008 upwards. For best code safety, the database collation is Latin1_General_CS_AS)
  1. Unzip and Restore database backup file 'ParallelBoostSQL2008V1_0.bak'
  2. Create the execution environment (see documentation chapter 2.4)
    • EXEC [dbo].[PROC_BOOST_Agent_CREATE_Jobs] @NamePrefix = DEFAULT, @InstanceCount = <desired # of parallel instances>
Operation (see documentation chapter 3.1)
  • Redirect your data modification SQL statement thru calling EXEC [dbo].[PROC_BOOST_Job_ADD_Entry]
  • Adjust configuration settings if required (see documentation chapter 2.3)
Further operation details can be found in the Product Manual.

Your review and feedback is welcomed !

Sample Call for SQL Statement Redirection (for included test table [dbo].[EXPORT_TEST_EXPORT] with 1.6 Mio rows)

DECLARE @JobID smallint
 

EXEC @JobID = [dbo].[PROC_BOOST_Job_ADD_Entry]
@CallingCode = '_MANUAL_',
@CallingVersion = 0.0,
@ObjectBase = DEFAULT,
@Context = DEFAULT,
@DataSource = DEFAULT,
@Catalog = 'ParallelBoost',
@UserContext = DEFAULT,
@StmtCore = 'UPDATE [#CATALOG#].[dbo].[EXPORT_TEST_EXPORT] SET [SRC_ROW_DATETIME_UTC] = getdate()',
@StmtFrom = 'FROM [#CATALOG#].[dbo].[EXPORT_TEST_EXPORT] AS ALIAS',
@StmtWhere = DEFAULT, --'ALIAS.[PK_TEST_EXPORT] > 60', DEFAULT
@SplitMode = DEFAULT, -- EVEN, MEDIAN, MULTI_STMT or DEFAULT
@SplitValueDataType = 'NUMERIC', -- NUMERIC, DATETIME, CHAR
@SplitValueExpression = 'ALIAS.[PK_TEST_EXPORT]',
@SplitDesired = DEFAULT,
@SplitExecSeq = DEFAULT,
@Priority = DEFAULT,
@TimeoutSecond = DEFAULT,
@ExecutionScope = DEFAULT -- 'ADD_ONLY', 'ADD_DISPATCH', 'ADD_DISPATCH_MONITOR'
IF @JobID < 0
PRINT 'ERROR'
ELSE
PRINT @JobID

Last edited Aug 26, 2011 at 6:56 AM by michael_ibax, version 31

Comments

No comments yet.