Viewing 15 posts - 226 through 240 (of 312 total)
I think it was more of an article on performance.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 3:30 pm
Steve Jones - SSC Editor (3/28/2014)
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 12:41 pm
Steve Jones - SSC Editor (3/28/2014)
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 12:38 pm
JoshDBGuy (3/28/2014)
For it to be 30 GB requires quite a bit of data, I would say that you need to look at the script to see what it's doing.
That's exactly...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 12:22 pm
JoshDBGuy (3/28/2014)
I see that you are doing a batch, how many records are you archiving? Does the data contain blobs? (look for text fields).
I don't know how many records are...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 12:03 pm
Jeff Moden (3/28/2014)
So, have you been shrinking the log file and that's how it got back down to 121 MB?
I am not, but yes they are being shrunk by another...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 11:46 am
Thanks a lot.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 11:42 am
Thank you so much guys for helping me out here. There is 1 more question I have. I can start a new thread but it is regarding the Tlog so...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 11:18 am
JoshDBGuy (3/28/2014)
Initial log file size is 121 MB and the autogrowth is 10 percent which currently equates to about 12 MB. Where do you see 30 GB?
I am sorry, what...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 10:47 am
samalex (3/28/2014)
One issue is the potential of one log or data file filling up the entire drive preventing the other data and log files from growing.
We already created...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 9:41 am
JoshDBGuy (3/28/2014)
New Born DBA (3/28/2014)
Please see the attachment.
That's actually two terabytes. That's your maximum file size, not the autogrowth amount. 10% is the amount your log file currently grows. If...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 9:36 am
The initial size is 121 and it is also set to auto-grow by 10%, restricted growth to 2097152MB which is not 30GB (My bad)
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 9:21 am
Jeff Moden (3/28/2014)
New Born DBA (3/28/2014)
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 9:18 am
JoshDBGuy (3/28/2014)
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 9:03 am
Come to think of it, I don't know how adding initial size to 1000 MB and set the growth to 1000 MB will help. The auto-growth of the log file...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
March 28, 2014 at 8:50 am
Viewing 15 posts - 226 through 240 (of 312 total)