|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:08 PM
Points: 175,
Visits: 719
|
|
|
|
|
|
SSChampion
        
Group: General Forum Members
Last Login: Today @ 12:19 PM
Points: 13,371,
Visits: 25,144
|
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Thursday, June 14, 2012 9:22 AM
Points: 1,
Visits: 20
|
|
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
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:08 PM
Points: 175,
Visits: 719
|
|
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 Microsoft SQL Server MVP Director of DBA Education, Red Gate Software www.bradmcgehee.com
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:03 PM
Points: 255,
Visits: 2,405
|
|
I like having practical, real-life examples and advice. Much appreciated. Thank you.
|
|
|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 5:30 AM
Points: 861,
Visits: 1,436
|
|
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
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Thursday, August 30, 2012 9:37 AM
Points: 44,
Visits: 202
|
|
JJ B (4/13/2011) I like having practical, real-life examples and advice. Much appreciated. Thank you.
I second this. Thank you!
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Friday, March 15, 2013 10:35 AM
Points: 594,
Visits: 654
|
|
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
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:08 PM
Points: 175,
Visits: 719
|
|
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 Microsoft SQL Server MVP Director of DBA Education, Red Gate Software www.bradmcgehee.com
|
|
|
|