Browse by Tags

Blog do Ezequiel
Portuguese PFE SQL Server Team


  • 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: The SQL Swiss Army Knife #5 - Checking Autogrow times

    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 exploring an alternative way of verifying autogrow times besides checking the ErrorLog for any recorded information, and that is when an error 5144 or 5145 occurs....
  • 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 (4 items)