Database Administration vldbs

Published on December 18th, 2014 | by Warner Chaves

7

Presentation: Best Practices for SQL Server Very Large Databases (VLDBs)

I had the great opportunity last April to present “Best Practices for SQL Server Very Large Databases” for SQLSaturday in Chicago. I got great attendance and the audience made some great comments and had great questions as well. During the preparation stage I asked every Database Consultant at Pythian what were some of their favorite tips/tricks/techniques to manage SQL Server Very Large Databases. As the amount of data we accumulate continues to get bigger this is becoming more and more of a challenge for every company.

I compiled all of their advice and came up with these categories that I called the VLDB Pyramid:

  1. Data Safety
  2. Storage
  3. Indexes
  4. Stats
  5. Miscellaneous

Each tip or trick falls into one of these, either about handling corruption, implementing compression, picking the proper data types, etc.

At this point I have added many annotations to the main points I cover in the presentation. If you’re currently being challenged with managing one of these Very Large Databases then I invite yo to check the presentation. There might be a thing or two that you might not have thought about and might help you out now or some day in the future!

Here’s the link: Best Practices for SQL Server Very Large Databases

Feel free to add any comments or questions to this post. It’s a very broad topic and there’s a lot to cover, I find that I still continue to learn about it to this day.

UPDATE: as a follow up to the feedback I’ve received from this presentation I created a related post of the “Top 10 Must-do Items for your SQL Server Very Large Database”. Please check that one out as well for added resources!

Tags: , , ,


About the Author

SQL Server Certified Master and MVP. DBA for MS technologies for over 10 years.



7 Responses to Presentation: Best Practices for SQL Server Very Large Databases (VLDBs)

  1. dsmvayani@yahoo.com' dawood says:

    I want vldb presentation and video tutorial links..

    • Warner Chaves says:

      Hi Dawood, you can see the presentation in the embedded prezi window in the post. If that’s not working for you, there’s also the direct link in the post as well. Regarding video, this particular presentation wasn’t recorded but if you go through the presentation and still have any specific question just come back here and post it. Thanks!

  2. amrit.chauhan1123@gmail.com' Amrit says:

    Very informative.Thanks a lot.

  3. devikadba@gmail.com' Devika says:

    Hi Warner,

    That was an interesting presentation .

    With reference to backup compression – what is the significance of stats=10 in backup command ?
    I have enabled compression for all dbs in the instance using EXEC sp_configure.

    Do you have any presentation /suggestions for Oracle to SQL Migration ?

    Regards,
    Devika

    • Warner Chaves says:

      Hi Devika! The stats=10 is just the % interval that SQL Server will print a progress message. “Backup 10% complete, 20% complete” etc.

      Oracle to SQL migration can be quite a project, specially if there’s a large amount of PL/SQL that needs to be translated to T-SQL. Data movement can be problematic with the bigger binary types as well but is usually straight forward with the more common data types.

      Definitely a topic that I’ll consider writing about in the future!

      • devikadba@gmail.com' Devika says:

        Thanks Warner… !! Please do let me know when you write on Oracle to SQL migration topic. Hope it is the near future :-)

        I understand except for SQL Express edition, the other editions dbs can be as large as 524PB. So if Oracle DB is huge then I guess the migration will be very challenging.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Back to Top ↑
  • Sign Up For Our Newsletter

    Stay up to date on the latest from SQL Server products and Features.

    Sign Up Now

    Sign up for mailing list and receive new posts directly to your inbox.

    We promise never to share or sell any of your personal information.

  • Recent Posts

  • Categories

  • Archives

  • Tags

  • Topics

  • Subscribe to our RSS Feed


    sqlturbo.com A SQL Server Web Blog
    Canada, Ontario, Ottawa.
    http://sqlturbo.com

    The Authors