Re: We quadrupled hardware power and reduced performance

From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 03/17/04 

Date: Tue, 16 Mar 2004 22:22:08 -0600

One thing to rule out is to update the statistics and see if that makes a
difference. 

--
Andrew J. Kelly  SQL MVP
"Randolph Neall" <randolphneall@veracitycomputing.com> wrote in message
news:#gk6#z8CEHA.1544@TK2MSFTNGP09.phx.gbl...
> We have been running a .Net and SQL Server app on an old four-year-old 500
> mhz HP server with 512 MB RAM and 20 GB harddisk, Windows 2000 Server.
Today
> we moved it to a new 2.16 gigahertz box with 1 GB RAM and 120 GB harddisk,
> Windows 2003 Server. We thought we'd see a dramatic improvement in
> performance. Instead it is worse than on the old computer.
>
> The new computer has two hardware mirrored drives, as I said, 120 GB
apiece,
> with no partition, just the C drive. We were doing only reads, not writes.
> Not sure where the bottleneck is. The new box is running at roughly 80 -
> 100% CPU capacity, which also came as somewhat of a surprise. Thought it
> would drop dramatically below the old box or at least, if that high, get
> through the process faster. But it was not to be.
>
> The processor on the old box was Intel, the new, AMD. Not sure if that
makes
> a difference.
>
> We did several tests with new box serving as server to other boxes. Then
we
> did all the action on the server itself, where it was both client and
> server. That did not seem to help much either, so things cannot be blamed
on
> the speed of our network.
>
> We are dumbfounded, wondering whether something is wrong with our new box,
> or if the large drives, not striped, would it the problem, or what...
>
> We are running MSSql Enterprise, using the default installation settings.
>
> Any ideas would be appreciated.
>
> Randy Neall
>
>

Relevant Pages

  • Re: Disk Configuration Best Practices
    ... > boot-time RAID utility to reconfigure back to RAID1, ... >> Andrew J. Kelly SQL MVP ... I converted a RAID1 array in my DC/Exchange Server to a RAID5 ... I have 5 drives in the SQL server ...
    (microsoft.public.sqlserver.setup)
  • Re: io recommendation
    ... The reason for placing the logs on their own raid 1 separate ... placement on the drives and decrease efficiency when reading and writing. ... Having 3GB on the server is good since the OS and any other apps that need ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: io recommendation
    ... Yes a Raid 10 will usually give the best performance. ... >> Andrew J. Kelly SQL MVP ... we have a compaq server we plan on using for a sql 2000 setup. ... >>> and it looks like the server can take 72gb scsi drives. ...
    (microsoft.public.sqlserver.setup)
  • Re: After manually undoing a recent MS Update, my server is a mess
    ... Keep in mind that I have seen OEM drivers up there so given that you've blown that image away, I can't say for certain that the 'critical' was 100% pushed by Microsoft. ... External USB is no replacement for local drives. ... LOL I show my naivety here when I say that I showed great diligence in my blind application of any MS suggested resolution to "Critical Errors" on my Small Business Server Monitor Report. ... When I got the first BSOD, I booted from the orginal CD and chose to only restore the System files. ...
    (microsoft.public.windows.server.sbs)
  • Re: After manually undoing a recent MS Update, my server is a mess
    ... information to login to my server remotely to look around--hoping he could ... External USB is no replacement for local drives. ... stored on) and chose to only restore the System files. ... The "Cases" drive was actually a shared folder on an external ...
    (microsoft.public.windows.server.sbs)
Loading