Browse by Tags

Blog do Ezequiel
Portuguese PFE SQL Server Team


  • Blog Post: SQL Server 2012 new high VLFs warning: Important update

    Hello all, If you follow this blog, this is another post on VLFs, a topic I’ve covered several times before. If you want to read more about it just click here . Also, all scripts in the VLF posts have been updated to support SQL server 2012. So, back in October I posted about the new high...
  • Blog Post: The “rumor” is true: SQL Server 2012 has a new high VLFs warning (Edited).

    Hello all, If you follow this blog, you know I blogged on VLFs several times before and if you want to read more about it just click here . I decided to investigate a bit on something Kalen Delaney mentioned today in a SQL PASS session. She heard that on Denali CTP3 (now officially SQL Server 2012...
  • Blog Post: SQL Swiss Army Knife #10 - VLFs again. What’s your current status?

    EDIT (11-01-2011): A parenthesis was missing making the log_size_MB value skewed. Thanks Luis! EDIT (26-03-2012): Updated script for SQL 2012 support. EDIT (19-11-2012): Added information from Fixing VLFs post , namely potential log size after fix, actual number of VLFs, amount of used VLFs, potential...
  • Blog Post: SQL Swiss Army Knife #9 - Fixing VLFs

    EDIT (09-08-2011): missing variable set for sql version. Thanks go to Calvin for finding this bug. EDIT (26-03-2012): Updated script for SQL 2012 support. EDIT (19-09-2012): Simplified logic. EDIT (20-09-2012): Changed grow settings if not SQL Server 2012. Hello all, Here is another post...
  • Blog Post: Can log files growth affect DML? Post-CU Update

    Hello all, A while back I blogged on how log files can affect DML performance , depending on their structure and growth ratio. It recently came to my attention (thanks Paul Randal) that a fix was published late last February, in KB2455009 , aimed at scenarios where one might experience slow performance...
  • Blog Post: Can log files growth affect DML?

    Hello all, A while back I blogged here about how a good strategy of log file growth could potentially impact ongoing operations with your SQL Server. It’s known that VLFs (number and size) impact on the performance of such actions as scanning all VLFs for transactions that are marked for replication...
  • Blog Post: SQL Server and Log File usage

    Hello all, I decided to talk about an issue I've recently dug a little deeper, and so i will talk about how and why Log files (and their growth strategy) affect recovery times, mirroring, replication, large data changes (batches), leads to disk fragmentation, and ultimately adds stress factors to SQL...
Page 1 of 1 (7 items)