You are here: Re: SQL Server Sizing - Hardware requirements for SQL Server 2005 « MsSQL Server « IT news, forums, messages
Re: SQL Server Sizing - Hardware requirements for SQL Server 2005

Posted by Greg D. Moore \(Strider\) on 10/25/06 02:22

"Parv" <Parveen.Beniwal.Daffodil@gmail.com> wrote in message
news:1161669853.698634.103110@e3g2000cwe.googlegroups.com...
> Hi all
> HPSERVER 370G4
> 3.2 Xeon Single processor
> 3GB RAM
> 1 SCSI 73GB 15000 RPM(OS & Transaction Log), 4 SCSI * 73GB with RAID 0
> (Data Files) and 2 IDE * 300GB (Backups)

Don't go down this road. Do NOT use RAID 0. This will quadruple your
chances of a failed drive giving data loss.

Put the transaction log on a RAID 1 or even RAID 10 setup.

But the data on RAID5 if you want to minimize disks. Otherwise you can use
RAID 1 or 10 if yo can spare the disks.

Move the backup drives to a different machine. If this one fails (say bad
fan, it overheats destroying memory or CPU) those backups are of limited use
untli you can build another srever to put them in.


>
> Reporting Server
>
> Board SE7520BD2V
> 2 x XEON 3.2 GHz CPU 800 FSB with 2MB Cache
> 4GB RAM
> 3 SCSI * 73GB with RAID 0 (Data Files and Transaction Log), 2 SATA *
> 300GB (Backups) , 1 80GB IDE(OS)
>
> I want to fullfill both of my requirements from a single . I want to
> know what upgrades or changes I need to do in the configuration
> according to the load and performence on existing servers. Here is the
> table of performence counters along with their values to show the load
> and performence for both of the servers.
>
> ReportServer Value
> FeedingServer Value
> Counter Instance Avg. Min. Max. Avg.
> Min. Max.
> Pages/sec 0.081 0 8.001 0.02
> 0 1.993
> Avg. Disc Queue length _Total 18.658 13.592 51.896
> 34.421 0 175.783
> % Processor Time _Total 36.841 5.469 64.453
> 79.837 54.688 100
> Buffer Cache hit ratio 97.702 93.595 99.463
> 97.41 77.261 99.989
> Checkpoint pages/sec 0 0 0
> 0 0 0
> Lazy writes/sec 1.243 0 30.003 14.263
> 0 97.194
> Page life expectancy 17 4 81
> 10 6 14
> Avg. Disk
> Bytes/transfer _Total 37934.133 7903.004
> 128427.747 53806.538 8025.801 141750.562
> Avg. Disk
> Bytes/Read _Total 16737.419 8192 42895.862
> 54228.822 8170.499 143489.965
> Avg. Disk Bytes/Write _Total 12298.494 0 65536
> 11708.014 0 92842.667
> % Disk Time _Total 77.555 49.976 261.966 760.356
> 12.534 4890.383
> Users Connections 17 17 18
> 195 185 212
> Batch Requests/sec 0.859 0 23
> 73.215 0 205.009
> Transactions/sec _Total 1.768 0 18.001
> 59.314 3 241.814
> Page splits/sec 0 0 0 1.03
> 0 5.007
>
> Please suggest what should be the configuration for my new server.
> Should I consider buying an Dual Itanium Processor based system with 16
> Gigs of Ram and 8 Hard Disks in Raid 0. Or Should I consider buying a
> Quad Xeon Dual Core Processor based system. Or may be my existing HP
> server can be upgraded to dual processor and 8 Gigs of Ram and 2-3 more
> hard disks? Pls recommend what should be the factors that sould be
> considered, guiding priciples and my approact to reach a decision.
>
> With Best Regards
> Parveen Beniwal
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация