Expert,
I wonder where I can check those questions for SQL Server 2000?
How many transaction in each day for SQL server 2000?
How many transactions in peek hours?
How many transactions per second?
Thank you,
Learner
In addition to SQL Profiler you can also query sysperfinfo
SELECT * FROM master.dbo.sysperfinfo
We do this in a scheduled task (runs once a minute) to log the counters we are interested in. In particular we monitor
SQLServer:Databases / Transactions/sec
SQLServer:General Statistics / User Connections
we also log / monitor
@@cpu_busy
If CPU, or Transactions, or User connections is over a preset threshold we show the Server Busy page on our website (for new sessions only) - which prevents new sessions whilst allowing existing sessions to finish-up and leave - the intention being that people already in the site can finish their tasks, rather than everybody being chucked off, or exterpencing timeout errors, etc.
You will have to monitor the database with SQL Profiler, or do a server side trace.
