Concurrency Control

I created an ETL Process which loads four different types of files into different tables in parallel. There is no issue with this parallelism as the sources and destinations are distinct. But I have a common log table where I log the status and timings of each load for any file type. When ever I start a new file load, I create an entry in this log table with the FileTypeID and LoadInProcess as 1 (this will be set to 0 for all other records of the same file type). At different stages of the load, I will pull the active LoadID of the current file type and update the same record with the timings and results. My code looks like this -





Code Snippet
SELECT

@LoadLogKey = LoadLogKey
FROM

SystemLoadLog (NOLOCK)
WHERE

FileTypeID = 1 and LoadInProcess = 1


IF @LoadLogKey is NULL

RAISERROR('Unable to retrive LoadLogKey for the current load!')

***Process1 Query
***Process2 Query
***Process3 Query

UPDATE

SystemLoadLog
SET

Process1Result = x,
Process2Result = y,
Process3Result =z
WHERE

LoadLogKey = @LoadLogKey






The first SELECT query is giving problems as different processes are using the same table to log the results and timings. The source files I load are too small that the data load finished in 1 or 2 seconds most of the time and within this timespan, I update the log atleast 10 times. So, if four different file types are loading, the hits to the SystemLoadLog can be as bad as 20 to 30 times in 1 second.

Can anyone let me know how to handle this?

Thanks in Advance!!!
Harish