Determine #transaction per second per db

Whats the best method of determining #trans per sec per db in a SQL2000 Enterprise sp3? Thx in adv.Depends on your view of what a transaction is but how about monitoring the
Transactions/Sec counter in Perfmon under SQL Databases.
--
Andrew J. Kelly SQL MVP
"LIZ" <anonymous@.discussions.microsoft.com> wrote in message
news:2C79D01A-6D04-4D5F-8FE5-2A6C0E1795DA@.microsoft.com...
> Whats the best method of determining #trans per sec per db in a SQL2000
Enterprise sp3? Thx in adv.|||You could also use the transactions even in SQL Profiler, which also
captures the database... You could save the trace into a SQL table and do a
query grouped by database
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"LIZ" <anonymous@.discussions.microsoft.com> wrote in message
news:2C79D01A-6D04-4D5F-8FE5-2A6C0E1795DA@.microsoft.com...
> Whats the best method of determining #trans per sec per db in a SQL2000
Enterprise sp3? Thx in adv.sql

design help

hey all,
can someone please help me design the following:
9/29/05 Cut Lawn $20
Date of Service Service Type Price Payment Due Trans Type Payment
Amount Payment Date
9/29/05 Cut Lawn $20 10/29/05 Bill
9/29/05 Cut Lawn $20 10/29/05 Payment $10 10/1/2005
9/29/05 Cut Lawn $20 10/29/05 Payment $15 10/14/2005
Here's what I have so far:
Customer table
Invoice
InvoiceDetails
And here's where I need some help
Would I need a payment table? if so, how would it link to the invoice?
Also, where and how would you keep track of past due amounts and customers
who pay more than the amount billed?
thanks,
ariStart here:
http://www.databaseanswers.org/data...oices/index.htm
-oj
"ari" <ari@.discussions.microsoft.com> wrote in message
news:40BCFA96-97FC-432E-B7E8-19F78FDA7D53@.microsoft.com...
> hey all,
> can someone please help me design the following:
> 9/29/05 Cut Lawn $20
> Date of Service Service Type Price Payment Due Trans Type Payment
> Amount Payment Date
> 9/29/05 Cut Lawn $20 10/29/05 Bill
> 9/29/05 Cut Lawn $20 10/29/05 Payment $10 10/1/2005
> 9/29/05 Cut Lawn $20 10/29/05 Payment $15 10/14/2005
> Here's what I have so far:
> Customer table
> Invoice
> InvoiceDetails
> And here's where I need some help
> Would I need a payment table? if so, how would it link to the invoice?
> Also, where and how would you keep track of past due amounts and customers
> who pay more than the amount billed?
> thanks,
> ari|||Awesome.
Thanks,
ari
"oj" wrote:

> Start here:
> [url]http://www.databaseanswers.org/data_models/customers_and_invoices/index.htm[/url
]
> --
> -oj
>
> "ari" <ari@.discussions.microsoft.com> wrote in message
> news:40BCFA96-97FC-432E-B7E8-19F78FDA7D53@.microsoft.com...
>
>