Category Archives: Technology

Database AutoGrowth

SQL Server Database AutoGrowth

Leaving the default settings for SQL Server AutoGrowth is an unhealthy practice.  As many will agree, the default growth rates should be changed .

OK.  So using percentage settings is a bad practice.  I don’t want to grow the database in 1 MB increments, and not touching it is bad too.  What am I supposed to do?  How can I best configure my SQL Server AutoGrowth settings?  Are there any best practices or recommendations for database autogrowth?   Aggghhhhhh!

Before I pull out my hair, let me digress…

Over the course of time, colleagues and experience have helped me draw up some general guidelines:

  • If the file size is less than 1 GB , then set the File Growth Rate for the data file to 200 MB .
  • If the file size is between 1 GB and 200 GB , then set the File Growth Rate for the data file to 1 GB .
  • If the file size is greater than 200 GB , then set the File Growth Rate for the data file to 10 GB .

The conditions in your environment may vary, but this is a good place to start.  Consider whether your database is a data warehouse, has a transactional focus, or very large database (VLDB).  Your goal is to minimize the number of times your database grows, but when it does, take the amount of storage you need without having to return to claim more too soon.

The final piece of advice, as any good DBA will tell you, is interview your users, measure your workload, monitor your database growth, and adjust settings for your specific situation.

Eye in the Sky

I walked by a construction site today while three men stood atop a small embankment.  Just another day at the site?  Oh no!  They caught my attention because one was handling a piece of headgear that I later determined were pair of goggles.  Another gentleman was carrying a large laptop looking device held against his torso.  It was strapped around his neck like a walking concessions vendor at a local ball park.  But instead of selling franks, he was looking towards the sky.  When I finally followed his line of sight, I saw what he was doing.  He was piloting an aerial drone.

This is not your dad’s (or son’s, OK…. or your) remote control helicopter or plane! The drone was similar to the hexacopter.

In addition to the many propellers, the drone had an on board camera.  The guy wearing the goggles was surveying the site from the air.  He would guide the pilot and tell him where to maneuver based on what he wanted to see.

I was amazed at how smoothly the flying device handled.  Not to mention silently.  The application of technology was truly amazing.  How often is it that we wish we could see things from a different point of view?  This team had an excellent bird’s eye view of their work.  It occurred to me very quickly how the cost of operating an aerial robot could be more cost effective than chartering a helicopter for the same time.  Not to mention it could fly far lower and be less disturbing.

What a great technology application!