Can bulk insert have a negative effect on cache

  • Hi guys,

    Just a simple question really. Can a large bulk insert clear pages from the buffer pool or negatively effect the plan cache?

    I am seeing increased compilations per second after bulk inserts and think that the 2 are linked?

  • Just a data insert alone will not affect plan cache (it sure can affect the rest of the cache). But, the update in statistics can affect recompiles. Maybe that's what you're seeing.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply