Sid B (siliconpi@gmail.com) writes:
Quote:
I am new to my company and have been asked to recommend a new
redundancy / backup plan for our online server. I've talked to the
other folks in the company and they have been describing an usual
feature of the server wherein if we try to install ANY new hardware
like a new harddisk, the system automatically formats everything.
(apparently this "resetting feature" kicks in even if we add more RAM
pieces!)
That sounds scary! Well, my expertise is SQL Server, so I cannot comment
on that part.
Quote:
The specifications are as follows:
CPU: Intel(r) Xeon (tm) cpu 3ghz (Dual processor)
Speed: 3 GHz
RAM: 4 GB
HDD: 2 x 140 GB (on RAID1)
Type: ADAPTEC RAID 1 SCSI Disk Drive
Server contains: Online Application and Database (SQL Server 2005)
Partitions: C: 30 GB, E: 110 GB
SCSI controller: (not known at this point)
>
>
The problems we're facing are as follows:
(a) Because of the low partition in C drive, we regularly have to run
maintenance tasks on the server which if we dont leads to our site
being inaccessible to our users.
(b) Our database is stored on E drive (about 60 GB of data). There is
a performance issue which our users face, but we are unsure of what we
should do to solve the problem.
The hardware configuration is not that impressive, but that does not
mean that it's insufficient. Your problem could just as well be a few
misbehaving queries, and fixing those, or just adding some indexes
could make your users very happy.
There are several ways to examine this. One way is to speak with users
to see if there are any specific operations that are slow. Another is
to ser up a trace that captures statements that runs for, say, more
than 100 ms, and the analyse that data.
There is a point when buying more hardware is cheaping than tuning,
particularly if tuning means lots of code to rewrite. But there is
also the other end when better hardware to some extent masks as
poorly implemented application, which you can get a lot better performance
from with small efforts.
--
Erland Sommarskog, SQL Server MVP,
esquel@sommarskog.se
Links for SQL Server Books Online:
SQL 2008:
http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005:
http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx