|
|
Posted by gabe101 on 12/20/06 15:10
Greg D. Moore (Strider) wrote:
> Argh, you're really stressing that machine.
Yeah, I agree. Unfortunately, it's not in the budget for us to expand
at this time. I will say this though, to me (and my mere two years
experience) it seems to be running very stable. Since we only run with
10 users, I've set SQL Server's memory allocation to 600MB and set
SBSMONITORING to 100MB, Exchange is being kind and staying between 575
- 600 MB and Symantec is occupying another 400 - 500. All together
I've still got about 800 - 1,000 MB of free RAM. My server report
shows an average of 18% busy disk time and both CPU's (shown as 4)
averaging about 8-10% use. Again, I only assume this is good because
I'm new to IT. I just got my degree two years ago. Would you say
our server is doing 'Good', 'Satisfactory' or 'Poor'?
> Try backing up over the wire to a UNC share on another machine. You are
> almost definitely stressing the disk I/O system on this box.
>
> A backup on the same machine won't do you much good if say the RAID
> controller fails.
I sheepishly have to admit my inexperience again and say that this
makes perfect sense. We are currently saving the noon backup on the
same system and I'll save the BAK file to another box starting now.
Thanks.
> Also, you may still want to look at transaction log backups, they'll
> generally be much smaller and you can do more often w/o impacting
> performance nearly as much.
My only concern here comes back to my inexperience with transaction
logs. Doing a restore through the Enterprise Manager is incredibly
simple with a full .BAK file. I've not done a transaction log restore
and have been told it's much more complex. I agree with you and Erland
here, but given our current situation, a restore from a full backup
file and then manually entering the day's transactions may ultimately
be just as simple to accomplish.
Thank you both for your comments and if you have anything more to say,
I'm still listening (and learning).
Navigation:
[Reply to this message]
|