Browse by Tags

Blog do Ezequiel
Portuguese PFE SQL Server Team

  • Blog Post: PAGELATCH_EX waits and heavy inserts

    Hello all, Recently I came across an issue over a table that was being inserted into quite intensively, by concurrent operations. The issue, which is not that uncommon, is dealing with PAGELATCH _EX contention, namely when a table has a clustering key that conforms with the concept of a small and...
  • Blog Post: SQL Swiss Army Knife #11.1 - Locking, blocking and active transactions

    EDIT (12-04-2013): Added page type information (PFS; GAM or SGAM) when wait type is PAGELATCH_ or PAGEIOLATCH_ . EDIT (23-05-2013): Fixed parse page issue. EDIT (17-10-2013): Added memory grant info, statements to blocking and blocked sections of blocking report, and fixed head blocker info. ...
Page 1 of 1 (2 items)