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: Table variables and row estimations – Part 2

    Hello again, On my previous post , we covered how the Query Optimizer handles row estimation when using Table variables under specific conditions. Following up on that, I will demonstrate other scenarios where the Query Optimizer must try to optimize queries when no statistics and histograms are...
  • Blog Post: Table variables and row estimations – Part 1

    Hello all, The subject of estimated rows vs. actual rows in plan execution has a lot of impact in query performance, and the source of these skews can be quite diverse, from outdated statistics, to incorrect sampling, or the inability of the query processor to know the value of certain variables at...
  • Blog Post: The SQL Swiss Army Knife #3 - View I/O per file - Updated

    Hello all, Here is another one focusing on SQL scripts that may help on everyday DBA tasks, following the series "SQL Swiss Army Knife". This script will return, very promptly, the overall I/O statistics for all databases in your server, ordered by stalled I/O, and is based on the sys.dm_io_virtual_file_stats...
  • Blog Post: A case of seeks and scans

    Hello all, A couple weeks ago while I was onsite, I was looking at some queries that had performance issues. To the customer, one in particular had become a conundrum that could not be easily answered with the usual approach of good indexing, simply because there was already a good covering index...
  • Blog Post: Adaptive Index Defrag

    Hello all, because the procedure usp_AdaptiveIndexDefrag has undergone a few more updates, starting now this post will be the only source of information for it, including a full change log at the end of this post . It’s also reachable from the links section on the right anywhere on the blog. ...
  • Blog Post: SQL Swiss Army Knife #7 - Adaptive Index Defrag

    Hello all, Sorry for the inconvenience, but the content of this post moved to the Adaptive Index Defrag post .
  • Blog Post: Best Practices on FILESTREAM implementations

    Hello all, Recently I was asked to advise a customer on a FILESTREAM implementation he was devising, and part of that ended up becoming this blog post that I hope can be of some help for you. When to use FILESTREAM? In SQL Server, BLOBs can be standard varbinary(max) data that stores the data...
  • Blog Post: SQL Server 2005 – Performance Dashboard installation steps

    Hi, To get the Performance Dashboard for SQL Server 2005 installed you must follow these steps: 1. Download the installation package from Microsoft Web Site: http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en 2. Install the MSI where you have...
  • Blog Post: SQL Server - Performance Counters, Thresholds, etc.

    These are normal questions: What counters should I select to monitor my SQL Server instance? What thresholds or values should I use to know when something bad is happening? Use this webcast to get answers: TechNet Webcast: SQL Server Performance Counter Guidance http://msevents...
Page 1 of 1 (10 items)