Home Forums SQL Server 2014 Administration - SQL Server 2014 I wonder why the number of reads increases during an insert test RE: I wonder why the number of reads increases during an insert test

  • March 3, 2015 at 3:50 am

    #1781301

    I found the cause.

    Each 10.000 rows I execute select count(*) on table in which I insert the 5.000.000 rows.

    This causes the enormous number of reads and explains why the lead times increase dramatically once the number of MB inserted grows beyond the max memory setting.

    When I remove the select count(*) from the script. The leadtime of the complete script is about 5 times faster and the increasing number of reads flattens.

    Kind regards

    Peter.