Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Knight » SQL Server Options to Avoid - SQL School...
Add to briefcase

SQL Server Options to Avoid - SQL School Video Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Brian Knight
Posted Wednesday, November 26, 2008 5:01 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Monday, August 13, 2012 1:06 PM
Points: 1,928, Visits: 224
Comments posted to this topic are about the item SQL Server Options to Avoid - SQL School Video

Brian Knight
Free SQL Server Training Webinars
Post #608973
mark-822230
Posted Tuesday, January 06, 2009 7:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 5:28 PM
Points: 4, Visits: 63
Go ahead and set your two terabyte database to autogrow by 10% and enjoy the wonderful performance this video suggests (as you look for a new job)...I dare you.

Or do something sane and calculate the maximum amount of wait time your users are willing to tolerate, determine the amount of space Sql Server can initialize in that time, and set the value appropriately.
Post #630564
info-950866
Posted Tuesday, January 06, 2009 7:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 29, 2009 5:47 PM
Points: 5, Visits: 8
Great Brian,

I'm a student right now and these tips and advices of yours are very usefull.

Thanks!
Post #630566
info-950866
Posted Tuesday, January 06, 2009 7:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 29, 2009 5:47 PM
Points: 5, Visits: 8
mark (1/6/2009)
Go ahead and set your two terabyte database to autogrow by 10% and enjoy the wonderful performance this video suggests (as you look for a new job)...I dare you.

Or do something sane and calculate the maximum amount of wait time your users are willing to tolerate, determine the amount of space Sql Server can initialize in that time, and set the value appropriately.


Oh Mark, If it is situation of 2 TB size database, that would be probably partitionated on 5-10 HDD... I think that Brian stated that it depends on the case, and the 10% was just an example. Man should think a little bit before. If I have a database with grow of 5-7% I´ll put 10%, but if it is much less, maybe is better to do that manually.

Planing is also important.
Post #630573
GilaMonster
Posted Tuesday, January 06, 2009 7:39 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:11 PM
Points: 37,741, Visits: 30,020
mark (1/6/2009)
Or do something sane and calculate the maximum amount of wait time your users are willing to tolerate, determine the amount of space Sql Server can initialize in that time, and set the value appropriately.


Or, better yet, monitor the free space and growth of the DB and grow it manually during maintenance time before the auto-grow kicks in.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #630577
MudLuck
Posted Tuesday, January 06, 2009 8:01 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 5:32 PM
Points: 125, Visits: 453
No sp_configure talk?

Should I turn parallelism on or off hahahha!!!

Are we just Gui's these days?

Brian your voice sounds different in person.

Loved the Analysis service class last April.

T


Post #630596
belgarion
Posted Tuesday, January 06, 2009 6:23 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 12:00 AM
Points: 54, Visits: 200
Hi Brian,

I click the play to watch the vid and get "welcome to jumpstart tv dot com" and what looks like the start of the vid ... but with the 'play' circle in the middle. If I click - I loop through the intro and stop at the same point. Basically I can't get past the "welcome to jumpstart tv dot com" intro. Using IE7, W2K3 Server Ent,
Post #631147
Anipaul
Posted Wednesday, January 07, 2009 10:29 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:35 AM
Points: 4,789, Visits: 1,336
It was playing ok in my machine. I am also using IE 7.


Post #631660
FFalcon1961
Posted Thursday, January 15, 2009 1:16 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 08, 2011 6:11 AM
Points: 31, Visits: 336
I believe the it was a suggestion and to base it on the size of your database and expected growth based on 2 months of growth.
Post #637538
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.