Browse by Tags

Blog do Ezequiel
Portuguese PFE SQL Server Team


  • Blog Post: SQL Swiss Army Knife #14 - Troubleshooting with Waits and Latches

    EDIT (30-04-2014): Detailed categorization of memory related waits Hello, The topic of Waits and Latches is quite well documented around the web, and there are several nice references that I list further down. Suffice to say that SQL Server waits, specifically threads that are executed have to...
  • 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. ...
  • Blog Post: SQL Swiss Army Knife #12 - Index information galore!

    EDIT (06/06/2012): Added script for all databases (may cause performance problems in large servers) and current database only. also fixed issue with partition aligned indexes. EDIT (19/11/2012): Added Heap information and redesigned duplicate and redundant index search. EDIT (18/12/2012): Fixed...
  • Blog Post: The SQL Swiss Army Knife #6 - Evaluating compression gains

    Hello all, Here is another one focusing on SQL scripts that may help DBAs, following the series "SQL Swiss Army Knife". This time we are evaluating table and index compression , specifically an approach on how to select the best compression method for a database object. There is a great deal of good...
Page 1 of 1 (4 items)