server load question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JI (anonymous_at_discussions.microsoft.com)
Date: 04/01/04 

Date: Thu, 1 Apr 2004 11:56:33 -0800

That is not very high but you are killing the ability of
the drives by having the log files (sequential read and
writes) on the same RAID array. Read the following chapter
out of the SQL 2k Operations Guide.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maint
ain/sqlops6.mspx

JI
>-----Original Message-----
>I have a sql2000 on win2k with:
>IBM 345
>I am not very experienced with SQL, I am helping trouble
shoot a
>possible performance problem.
>
>hardware
>2 - 2.4GHz Xenon processors
>2.6 Gb memory
>hardware RAID 5 across 5 10K SCSI internal disks
>OS, SQLserver, Logs, and Database files all on the raid 5
array
>
>It is running 34 relativly small databases of various
sizes and loads
>
>It sometimes has a peak load of up to 455
transactions/second total
>across all the databases. Is this considered high? I
have been told
>it is "very high". That doesn't seem like a heavy
transaction load for
>this hardware to me. What is a high transaction/second
load for
>hardware like this?
>
>We are getting some peaks with up to 1700 memory
pages/sec which seems
>to me to be the problem. CPU load is fine and disk queue
length is
>fine too.
>
> I think we may need more memory or memory tuning, not a
whole new
>box.
>
>thanks for your opinions
>.
>

Relevant Pages

  • Re: Working with very large text files
    ... > I'm working on a server which writes text to large log files. ... > perl tries to load the entire file into the memory and fails when XP is ...
    (perl.beginners)
  • Re: Memory limit reached with Windows Mobile
    ... That would explain the memory problem - you just can't do that. ... You have to load stuff when it's ... All native DLLs get loaded ...
    (microsoft.public.pocketpc.developer)
  • Re: Memory limit reached with Windows Mobile
    ... That would explain the memory problem - you just can't do that. ... Once I reached the 12 Mb limit, I cannot load any DLLs, yet if I ... Actually, simply by loading our 18 Native DLLs, we reduce the Virtual ...
    (microsoft.public.pocketpc.developer)
  • Re: Generating one table with a terabyte of data
    ... Take any simple string matching issues and run them as external C code on the files before loading. ... not match the job but can be adjusted for greater performance by changing memory type or adjusting IO layouts. ... them after a bulk load. ... Another thing is to split the updates across file sets. ...
    (microsoft.public.sqlserver.dts)
  • Re: fps modding
    ... > Yeah the memory usage used to be really high for no reason - but they've ... hl2 without it bothering to log in and such. ... one can't expect new games to load as ... >> rebuild and load a map. ...
    (comp.games.development.programming.misc)