ProLiant Servers (ML,DL,SL)
cancel
Showing results for 
Search instead for 
Did you mean: 

Client makes doubt in Proliant server perfomance!

 
Igor_31
Advisor

Client makes doubt in Proliant server perfomance!

A customer purchased Proliant ML370G3(2xX3.06,RAM 1024,5x72Gb, SA641, Wi2k) for their SQL2000 accounting aplication. He suppose that the server works slow.
What Proliant server perfomance meter does exist? I want to show for the client a real metered processor,disks,memory characteristics.

P.S. Is it necessary to turn off a write cache on SA for SQL2000 aplication?

8 REPLIES
Doug de Werd
Honored Contributor

Re: Client makes doubt in Proliant server perfomance!

Here are some white papers on tuning SQL Server on ProLiant. These are from the HP Active Answers web site (http://www.compaq.com/activeanswers)in the database section.

http://h71019.www7.hp.com/ActiveAnswers/Render/1,1027,5264-6-100-225-1,00.htm

http://h71019.www7.hp.com/ActiveAnswers/Render/1,1027,5265-6-100-225-1,00.htm

http://h71019.www7.hp.com/ActiveAnswers/Render/1,1027,5108-6-100-225-1,00.htm

For performance monitoring, you can use the Windows Performance Monitor.

Thanks,
Doug

Expert in ProLiant Clusters
Doug de Werd
Honored Contributor

Re: Client makes doubt in Proliant server perfomance!

one more thing, you should definitely leave the write cache turned on. It is battery backed, so if you lose power it will keep the data in cache memory until teh next time you boot. This is especially important for the transaction log files, which are basically a set of sequential disk writes.

Thanks,
Doug
Expert in ProLiant Clusters
Igor_31
Advisor

Re: Client makes doubt in Proliant server perfomance!

Thank You for answer.

There is more precise definition!
Client has SA 641 controller. In ACU I see
that it has not write acceleration (100% read/0% write)!
But a nature of client's application is a prefered writing operation.
That's a problem.
How to tune and optimize the server?
Martin Breidenbach
Honored Contributor

Re: Client makes doubt in Proliant server perfomance!

Does that Smart 641 does have a battery backed write cache (add-on module) ?

If not - get one, it really helps.

RAID5 has a bad performance for sequential write operations. Transaction log files are written sequential (BTW same problem with Windows swap file).

So it may make sense not to put them on a RAID5 but on a RAID1.
Igor_31
Advisor

Re: Client makes doubt in Proliant server perfomance!

No, this SA641 has not battery write cache.
(And in near-term outlook it will be too.)

Is it mean that it has a poor write perfomance? And is it mean that HP planned it for small database with a prefered read operations?
What potentialities for tuning do I have?
O key, I will create RAID 1. And more?
And what about stripe size?

Martin Breidenbach
Honored Contributor

Re: Client makes doubt in Proliant server perfomance!

Sorry but I'm not a SQL tuning expert.

AFAIK database server do lots of random read/write. Random disk IO causes lots of head positioning operation and these are slow compared to the difference that RAID1/RAID5 may cause.

Sequential write operations don't do many head positioning operations because sequential data usually is located in sectors which are on the same track. Here the write speed of RAID1 and RAID5 makes a difference.

So you can put OS and transaction logs on RAID1 and database data on RAID5. Or put everything on RAID1+0.

But there may be other bottlenecks. You can use performance monitor to locate bottlenecks.

Processor:
Processor % > 80% - upgrade processor
Also check:
user time %
priviledged time %
interrupts/sec

System:
pocessor queue length should be less than 2-5. if not upgrade processor

Memory:
pages/sec > 100 needs more memory
check cache/bytes

Disk:
disk time % if 100% for a long time increase number of hard drives
seeks/s
avg queue length should be <2-5

Network/server service:
bytes total
1 MB/s for 10 MBit
10 MB/s for 100 MBit

Doug de Werd
Honored Contributor

Re: Client makes doubt in Proliant server perfomance!

Your options at this point are very limited if you cannot add the write cache module. The reason that you only have the option for 100% reads in the ACU is because there is no write cache at all unless you add the additional write cache upgrade. So there is nothing there that can be configured. About the only other thing that you can do is to separate the database transaction logs from the database files. Create a RAID 1 mirror set that consists of 2 physical drives, and use the entier drive size for just one vo9lume (do not create any other volumes thatr use these two drives. Use this for the database transaction logs. Then create another RAID 1 (with two drives) or a RAID 1+0 (with more than 2 drives) to be used for the database tables.

But without a write cache module on teh controller, there is only so much that you can do.

Thanks,
Doug
Expert in ProLiant Clusters
Igor_31
Advisor

Re: Client makes doubt in Proliant server perfomance!

Thanks.
What perfomance will be expected after
perchasing BBWC for SA641?