SQLServerCentral Best Practices Clinic: Part 2

  • Brad McGehee

    SSCertifiable

    Points: 5272

    Comments posted to this topic are about the item SQLServerCentral Best Practices Clinic: Part 2

    Brad M. McGehee
    DBA

  • Grant Fritchey

    SSC Guru

    Points: 396692

    Excellent selection on the feedback, Brad. I also like your advice on filegroups and files. It's not something I had considered before, but certainly will going forward. I can't wait to see what else people find.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Fred Williams-487170

    SSC Rookie

    Points: 25

    Thanks for the article but can you supply some performance measurements to quantify the benefits of making those changes?

    Otherwise statements like this:

    " Just think of the resource hit (over time) the database took each time it grew, and think of all the physical file fragmentation this has contributed to, further hurting performance."

    are just too subjective to really be helpful..

    Thanks

  • Brad McGehee

    SSCertifiable

    Points: 5272

    Fred Williams-487170 (4/13/2011)


    Thanks for the article but can you supply some performance measurements to quantify the benefits of making those changes?

    Otherwise statements like this:

    " Just think of the resource hit (over time) the database took each time it grew, and think of all the physical file fragmentation this has contributed to, further hurting performance."

    are just too subjective to really be helpful..

    Thanks

    Since this is after the fact, and the previous data doesn't exist for SSC, I can't tell you the actual performance hit. On the other hand, when I have time, perhaps I can put together a test and write up the results to demonstrate my point.

    Brad M. McGehee
    DBA

  • JJ B

    SSCertifiable

    Points: 5042

    I like having practical, real-life examples and advice. Much appreciated. Thank you.

  • Andre Guerreiro

    SSCertifiable

    Points: 7319

    Very concise and a great selection of best practices. I will study your advice on filegroups more closely. This is one of those articles that make me keep visiting SQLServerCentral.

    Thank you.

    Best regards,

    Andre Guerreiro Neto

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

  • JHop34

    SSC-Addicted

    Points: 448

    JJ B (4/13/2011)


    I like having practical, real-life examples and advice. Much appreciated. Thank you.

    I second this. Thank you!

  • Peter Trast

    SSCarpal Tunnel

    Points: 4332

    I have never seen or heard of a best practice for separating system and user objects, although your explanation sounds good on the first read. Is this your own best practice or has Microsoft ever held this point of view? Or have they ever dismissed it? I tend to stay close to best practices until given a reason to do otherwise.

    Thanks for another great article! On to the next!

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • Brad McGehee

    SSCertifiable

    Points: 5272

    Peter Trast (5/11/2011)


    I have never seen or heard of a best practice for separating system and user objects, although your explanation sounds good on the first read. Is this your own best practice or has Microsoft ever held this point of view? Or have they ever dismissed it? I tend to stay close to best practices until given a reason to do otherwise.

    Thanks for another great article! On to the next!

    I have heard many people suggesting this, but it is highly recommended by Kimberly Tripp in her SQL Server Internals Immersion training, which I recently attended. I have not done much experimenting with this, but I intend to do so in the future.

    Brad M. McGehee
    DBA

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply