I thought we scared you away. I know I needed a break from here.
While I would have liked to never participate in or see this thread
again (& to try to recoup some of the time I wasted here by avoiding
usenet in general for a while) much of the time I've been talking
about my desire for you to answer my questions & respond to your
particular situation - so it's only right & not blow you off & respond
(esp as no one else has yet).
On Mon, 31 Jan 2005 11:54:21 -0500, "Chris Guimbellot"
I figured I would start out with a little bit about the box itself and what
we use it for. Basically, we are a small office of about 20 people (only
about 15 of which are logged in at one time). The box is a PIII1GHz with
512MB of RAM. In regards to the SBS setup, of course Exchange is running all
the time and most of my users have Outlook open all the time. SQL, on the
other hand, has only one database (in addition to the built-in ones) and it
is not transactional. It simply houses info and may get changed once or twice a
day.
Well then my inference was wrong. 40gigs & growing of mainly SQL,
Exchange & Fax sounded to me like a much larger more write intensive
SQL environment. That's because you didn't mention file service or
software management responsibilities (which can take up a lot of
space) & Exchange space is often contained through quotas & fax space
is often be limited through archival after a certain limited period of
time.
It's not necessarily common but there are some small businesses or
certain business types where even a handful of really good employees
or contracts can make a decent footprint on the SQL on a small
machine. If everything is so small that 512 ram is enough to hold the
database & everything else & everyone is always completely happy this
is an entirely different animal (is it?).
Problem for me was different ppl are looking for or value different
things so a statement like "works great" for one person can be a
mainly reliability & availability statement. For someone else it can
be a mainly performance statement. I can only therefore take it to
mean "meeting needs" in basic, nonspecific terms. If works great
means every one has instant, zippy access to everything at all times &
data & workstations are growing extremely slowly you can likely ignore
most of this thread's performance "discussion" or at least take it
with a grain of salt. (sorry)
I use roaming user profiles, and send faxes, etc (of course I bought
fax boards to relieve pressure from the processor). The standard small
office server-type stuff.
roaming profiles, software management, etc (infrastructure type stuff)
can bog down the network so were mentioned in the lan
performance/bottleneck generalization/hypothesis. My guess is these
activities should not really severely impact your environment- but you
have to tell us. Hmm, multiple fax boards on a small, entry level,
budget server. So faxes esp mass faxes play a pretty significant
role?
CURIOUS GEORGE
In regards to where a bottleneck (or potential bottleneck) could be, I have
no idea. I dont know how to test those particular things such as the NIC,
RAM use, disk writes, etc. I would be happy to learn how though if either of
you knows any sites, tests, etc. Also, for what it's worth, the NIC is a
simple 100Mb/s (you were right kony) so do not have any gigabit equipment. I
guess I would need a new switch too if that was the case that the NIC was a
bottleneck. In essence, I do not know how to perform tests so that I could
effectively answer your question. Even if I could, I have no benchmarks to
compare against.
You primarily want to identify something that is being hammered and
does, or has the potential in the near term with expected growth,
create a slowdown the users will notice. If everyone is happy and the
machine can withstand projected growth there is no benefit in dealing
with a benchmark number as it is mainly used for comparative purposes.
My exaggeration re the nic was simply to make the point we don't know
much about the computer & the network & it's important. I wasn't
really trying to guess it. For example a graphics design firm that's
constantly moving largeish files between the server & the workstations
(who actually manipulate the files) is going to have different needs &
different bottleneck areas to look at than say a billing service where
the workstations primarily send small sql requests the server has to
chew on. What about say a Radiology practice with both large images &
billing depts over both lan & wan. These could all easily be called
"small businesses" with 20 employees or less, all requiring mostly
file service, SQL, Exchange, & Shared Fax, & all with very different
needs & potential bottleneck sources.
I'm not telling you to upgrade the switch &/or nic just yet (unless
they're getting hammered & there's a problem). Just FYI the
inexpensive Intel Pro adapters can work together well and the adaptec
10/100 quad server nics can be inexpensive & solid. Esp with a good
switch, port aggregation or gigabit server link can be a simple cheap
upgrade that can help many Fast Ethernet users gain access to the
server. It's a possibility even on a budget server but there are
limits to what you can realistically expect here when so much is on
the same 32/33 pci bus or some el-cheapo switches.
How do you identify bottlenecks? by monitoring & studying the
server's load and the demands during the day, especially busy
"crunch-time" type periods. The bundled OS & SQL monitoring tools as
well as the websites I cited are a good place to start & digest the
concepts. Specifics & how you set up the monitoring are going to
depend largely on what you start noticing & specifics of use/needs but
will focus on the core HW components: CPU, RAM (& virtual memory),
Disk IO, Network Interface & may need to look at the core software
requests of said HW. Benchmarking, per se, may only play a smaller,
secondary role in all this; it will provide a basis for determining
the performance benefit of a specific upgrade.
CURIOUS GEORGE
Inside the server, I have two disks: the first is my main drive. It is a
SCSI drive with 40Gb of capacity (this is the one running out of room). The
second drive is a 10Gb ATA drive that I put in it a long time ago for
temporary purposes. Actually, I need to pull it out because it is ancient.
It needs to go into the circular file.
The confusion (& why I asked) was from calling it a 40gig drive (which
is an ata capacity) as opposed to what I guess now is really a 36gig
scsi drive. Problem is, from a server performance perspective, even
an older scsi drive with significantly less raw thruput, can often
deliver higher IOs than "faster" & newer ATA drives. It's still hard
to say therefore from this description what you need to be happy and
how that steers you away scsi or ata or ATA/firewire, etc. Also there
is some performance benefit with NTFS simply by moving to a volume
which is less than 80% full. I will agree somewhat with Kony here in
that 512MB ram is not a lot for a server & that adding ram may help
things (if needed). Whether it does & how much really depends on the
details.
Upgrade advice? Ok so get rid of the ancient ata drive if it doesn't
help. You have a choice now mainly between:
1. keep the 36GB scsi drive & add a small array for the data
2. do the same as 1 but also upgrade that 36GB drive to an array
3. copy over the present 36GB drive onto a larger capacity bootable
array.
It may not be necessary to separate everything over different
controllers/arrays (although ppl frequently recommend it for several
reasons). Some of this decision depends on whether I was over-parsing
your words & you did or did not in fact notice the drive thrashing
heavily & whether you feel there is some ease of
recovery/serviceability by separating OS & data stores & that the
extra SW & HW configuration changes & expense are worth it.
CURIOUS GEORGE
Great guess. Actually, it is an HP SureStore 40, a DLT4000 mounted
externally and connected to the SCSI card in the server. It is not an
autoloader. I manually switch the tape every morning. I guess the 4000 part
would be why my backup is going slow.
Really backup time is not that important. Restore time, ease, &
reliability is. If it takes a full business day or longer with you
babysitting the machine & twiddling your thumbs to do a complete
restore in the event of a disaster, that is a problem. The business
will loose a lot more money than the price of a new DLT. (FYI if you
are patient you should be able to sniff out a new SDLT1 or LTO1
autoloader in the $1000-$2000USD range on ebay. The VXA2 (stand alone
& autoloader) are also good budget options (that is to say the drive
NOT the tapes). Remember while DLT7000 is a good value, it is "only"
35gigs uncompressed/cartridge & you'll be buying new cartridges for it
anyway)
In regards to the full versus differential
backup, all of the SBS MVPs told me to, as well as do themselves, a full
backup every night. They have always known exactly what was going on, so I
trust their opinion and will stick with the full backups every night.
Besides the length of time they take to complete, the full backups and
SureStore have never let me
down.
Many ppl don't do full daily backups basically because they chew
through storage, time, & generate a lot of extra wear & tear. With
incrementals/differentials you are trading some convenience through
simplicity for convenience through cost & time & media esp for
retaining multiple backups.
However full backups still need to be done & incrementals need to be
coalesced into full ones at some point or some way anyway - so I'm not
going to say it's a wrong strategy. Full backups certainly work & are
straightforward. It's a good & safe recommendation. Whether the
strategy is wrong really depends on what you are doing with these
tapes. If every day or every week you are simply overwriting the same
tapes and loosing ALL those old snapshots without any media rotation
or offsite transport; that's not cool (yeah you're probably not doing
that)
By the way, I use the backup program in Windows to do the job. If I do
need a DLT7000, that is not a problem. I can get one relatively
inexpensively. I would however rather not buy one if I dont have to, but I
know that as my data growns, so will the backup time.
as will the restore time/downtime when the business needs it.
no more than one tape per disk volume is often not a bad strategy, esp
with no autoloader. With the DLT 4000 you are looking at up to 3
tapes & manual changes per day or per restore (in the near term).
This can be a problem. It also may be coming close to exceeding your
backup window in the near future. Incrementals/differentials will
help with ease of backup & shorten the backup windows to some degree,
but that "solution" still neglects the restore (which is really all
that matters in the end).
Also, since we are
moving our Marketing department (only two uesrs) from Mac to PCs, I am about
to put a few more GB of files on the server, probably necessitating the need
for a higher capacity tape drive, and definately more storage be it RAID or
a simple HDD. Also, Curious...what are you referriong to by 'value line of
DLTs'? I have never heard of that.
i.e. the DLT1, DLT VS80, DLT VS160 as well as the drives in this
roadmap listed as providing "Value" as opposed to "Performance":
http://www.quantum.com/am/products/dlt/technology_roadmap.htm#top
They're not necessarily bad or lesser quality (AFAIK) there are just
some nuisances that bother me like special cartridges that are harder
to get on discount, slower speed (esp the DLT1), & format
compatibility issues. The lower up-front cost tends to dissolve over
the lifecycle IMHO. Also if you are interested in the DLTIce feature
for compliance you may need to avoid these (I think).
I guess the thing to do now is to check for the existence of a bottleneck,
and if so, fix it.
That is _if_ there is a bottleneck that needs fixing now or that needs
to be planned for when future growth & lifecycle intersect. There was
much ado over a statement I made that began with: "Well I think he did
allude to some problems" & ended with questions to clarify your
situation. You've answered the backup issue & responded to these
questions. Now you still have to determine the disk needs & load
specifically.
Apparently this looks like more of a basic file & fax server than much
of a SQL or mail server; so the balls in your court again. I'm not
going to make any more inferences about allusions here & invite you to
fill in the blanks esp your potential confidence (or lack thereof) in
current performance & whether there is likelihood of performance boost
of a raid upgrade exceeding need or whether a whole server replacement
is forthcoming.
As I mentioned above, any help with that would be great.
Now that I have thought about the coming switch from the Macs and adding
those files to the server, I now think I should definately consider swithing
to a higher capacity tape drive in addition to any upgrades I make to the
hard drive system. There needs to be some upgrade done on storage ( I figure
we all can agree on that). I guess the only question now is what kind.
My vote is a smaller raid 1 boot array & a 74 or 80 gig or better raid
1 for data (not _necessarily_ a performance tip here) on a HW
controller that could handle online array expansion/migration. From
the looks of things, though, everything on a single array might be OK
too. RAID 3 or 4 might be OK (maybe Mylex U160 scsi with 128MB for
"budget") but I am not really endorsing it or raid 5.
It doesn't sound like you really need to high IO's of more smaller
drives for a particular capacity or the fastest 15K screamer.
Internal arrays could work unless you are sold on the advantages on
hotswap, which likely doesn't fit in your chassis. I'm not going to
touch a scsi vs ata suggestion. You doubtless already have some ideas
about their strengths based on current usage.
The storagereview.com's reliability database is an interesting project
you might want to look at before drive purchase. Give thought to the
3ware, LSI, & to some extent IBM controllers. Despite the big name
I'm not sure Adaptec is a great pick here. I don't recommend getting
the cheapest controller you can find or a hotswap backplane if it's of
mediocre quality.
Once again, I appreciate the help and the insight and I look forward to your
responses. Thanks again,
Chris
no prob. I hope this wasn't an all around long-winded time waster
that has sent you on a wild goose chase. Even if I totally
misinterpreted your setup, it still wouldn't hurt to project needs &
capacity & start thinking about the next major upgrade esp or even if
it just gives you that much more confidence in the current platform &
its expected longevity. "Obsessing" over every detail of a smaller
setup seems like overkill but it tends to not really be all that much
work. If it saves you from "mistakes" it is a worthwhile investment.
If other Mac->PC conversions & departments join this server in the
future you will have to reanalyze, but you will do so armed with
baseline measurements & projections that make life a lot easier. You
won't ever be starting from scratch again or caught with your pants
down & can respond or make suggestions to deal with changes quickly.
As long as no one feels threatened by your analysis/suggestions your
extra work here can pay off.