Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLServerCentral Best Practices Clinic: Part 2 Expand / Collapse
Author
Message
Posted Wednesday, April 13, 2011 12:00 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:06 AM
Points: 176, Visits: 728
Comments posted to this topic are about the item SQLServerCentral Best Practices Clinic: Part 2

Brad M. McGehee
DBA
Post #1092570
Posted Wednesday, April 13, 2011 5:36 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 8:22 AM
Points: 14,205, Visits: 28,534
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 Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1092736
Posted Wednesday, April 13, 2011 9:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 21, 2013 12:33 PM
Points: 1, Visits: 21
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
Post #1092907
Posted Wednesday, April 13, 2011 9:51 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:06 AM
Points: 176, Visits: 728
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
Post #1092955
Posted Wednesday, April 13, 2011 11:36 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:52 PM
Points: 266, Visits: 2,613
I like having practical, real-life examples and advice. Much appreciated. Thank you.
Post #1093046
Posted Wednesday, April 13, 2011 11:38 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, December 15, 2014 3:02 AM
Points: 912, Visits: 1,500
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
Post #1093048
Posted Monday, April 18, 2011 10:09 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, November 1, 2014 8:54 AM
Points: 46, Visits: 219
JJ B (4/13/2011)
I like having practical, real-life examples and advice. Much appreciated. Thank you.

I second this. Thank you!
Post #1095108
Posted Wednesday, May 11, 2011 8:45 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, June 13, 2014 3:03 PM
Points: 594, Visits: 655
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
Post #1107022
Posted Wednesday, May 11, 2011 8:51 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 16, 2014 10:06 AM
Points: 176, Visits: 728
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
Post #1107028
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse