Home Forums SQL Server 2014 Administration - SQL Server 2014 Exclusive PageIOLatch RE: Exclusive PageIOLatch

  • May 24, 2017 at 5:39 am

    #1943956

    GilaMonster - Wednesday, May 24, 2017 4:34 AM

    Errr...

    PAGEIOLATCH_EX is a latch taken when the page is being read into memory so that the insert can occur. If you're seeing these high, there's probably not enough memory for the database to keep the busy portions of the database in memory. consider adding memory or tuning queries/indexes so that they read only the portions of the tables that they need.

    Queries/indexes in general. Inserts don't use indexes.

    Well, not exactly. They sure do add rows to 'em during the inserts. There's just not a seek or scan of the index during that part of the processing.

    "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