I have one answer…. Response time.
It sounds like you are getting yourself into a mess.
------------------------------
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Jeffery Thomas
*Sent:* Friday, April 27, 2007 11:02 AM
*To:* Oracle-L Freelists
*Subject:* "Performance Counters"
We have a SQL Server team going to manage a new vendor-built application
on 10g RAC (Solaris).
They have zero experience with Oracle. They are asking the Oracle team
for 'performance counters'
similar to what they use with SQL Server so that they can identify
"satisfactory performance criteria" to be
used as non-functional requirements for the vendor building the
application.
The ones identified for SQL Server were:
SQL Server: SQL Statistics: SQL Compilations/Sec counter must not exceed
100 per second over a 2 minute period.
Average Disk Queue Length, averaged over a 2 minute period must not exceed
2.5
SQL Server: Buffer Cache Hit Ratio should exceed 90% measured over a 2
minute period.
The CPU usage must not exceed 35% averaged over a 2 minute period.
The SQLServer:LockWaitTime must not exceed 2ms measured over a 2 minute
period
If you've got a vendor building an application for you -- what kind of
benchmarks -- if any -- actually make sense with
respect to performance criteria that the vendor must meet?
Thanks,
Jeff
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.467 / Virus Database: 269.6.1/777 - Release Date: 4/26/2007
3:23 PM
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this message in error, please contact the sender and delete the material
from any computer.
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.467 / Virus Database: 269.6.1/777 - Release Date: 4/26/2007
3:23 PM
