Re: "Performance Counters"
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: jeffthomas24@xxxxxxxxx, "Oracle-L Freelists" <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 27 Apr 2007 19:06:14 +0100
you are going to have fun! In an ideal world I'd be looking at defined
transactions and setting targets for elapsed time EM can measure this.
On the other hand what they've given you are technical efficiency
measures, they've a long way to go.
On 4/27/07, Jeffery Thomas <jeffthomas24@xxxxxxxxx> wrote:
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
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l
Other related posts:
