add arraylist, sql server transaction and lock pages.