|
|
|
SSCommitted
Group: Moderators
Last Login: Tuesday, June 23, 2009 3:06 PM
Points: 1,922,
Visits: 194
|
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, August 13, 2009 8:23 PM
Points: 4,
Visits: 41
|
|
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.
|
|
|
|
|
Forum 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!
|
|
|
|
|
Forum 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.
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Today @ 2:21 AM
Points: 14,804,
Visits: 10,597
|
|
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
We walk in the dark places no others will enter
We stand on the bridge and none may pass
|
|
|
|
|
Valued Member
Group: General Forum Members
Last Login: Monday, October 12, 2009 5:49 PM
Points: 66,
Visits: 164
|
|
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
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, November 17, 2009 11:07 PM
Points: 36,
Visits: 44
|
|
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,
|
|
|
|
|
Hall of Fame
Group: General Forum Members
Last Login: Thursday, November 12, 2009 7:14 AM
Points: 3,295,
Visits: 964
|
|
It was playing ok in my machine. I am also using IE 7.
|
|
|
|
|
SSC Rookie
Group: General Forum Members
Last Login: Thursday, October 01, 2009 11:51 AM
Points: 25,
Visits: 331
|
|
| 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.
|
|
|
|
