I am working on a Critical database system that is currently working on an underpowered server (Compaq DL380, dual 1.2ghz, 6 gbyte memory, Dual Raid 1 Arrays) The server was not originally meant to handle the heavy load this server currently handles.
As a consequence I sit most often at 80% plus CPU usage on both CPU's and often max at 100% causing user timeouts.
Compaq/HP has a Hardware 'Sizer' tool for SQL 2000 that takes your input and recommends hardware configurations.
Some of the input items it wants are:
- Maximum per Hour Transaction Rate
- Maximum number of database connections
- Amount of HD space Reserved for DBase (Current Dbase is @ 2 Gbyte 'when shrunk' - and growing)
- Amount of Space to Reserve for the Transaction Log (at Last look it was about 10gbyte)
The utility Compaq/HP provides assumes you don't already have a system in production. Well, I do and would like to use actual data as opposed to AWAG (A wild arse guess).
How can I measure the Maximum Per Hour Transaction Rate and Maximum number of dbase Connections. Is there an easy way to monitor the system for these, or is there a utility I can use?
Also what considerations should I provide for the Dbase and Transaction Log space?
This server has about 250 Active Users on it constantly, and at least 10 services pushing transactions in the background.
Any Help or Suggestions you can provide would be greatly appreciated. Thanks!
As a consequence I sit most often at 80% plus CPU usage on both CPU's and often max at 100% causing user timeouts.
Compaq/HP has a Hardware 'Sizer' tool for SQL 2000 that takes your input and recommends hardware configurations.
Some of the input items it wants are:
- Maximum per Hour Transaction Rate
- Maximum number of database connections
- Amount of HD space Reserved for DBase (Current Dbase is @ 2 Gbyte 'when shrunk' - and growing)
- Amount of Space to Reserve for the Transaction Log (at Last look it was about 10gbyte)
The utility Compaq/HP provides assumes you don't already have a system in production. Well, I do and would like to use actual data as opposed to AWAG (A wild arse guess).
How can I measure the Maximum Per Hour Transaction Rate and Maximum number of dbase Connections. Is there an easy way to monitor the system for these, or is there a utility I can use?
Also what considerations should I provide for the Dbase and Transaction Log space?
This server has about 250 Active Users on it constantly, and at least 10 services pushing transactions in the background.
Any Help or Suggestions you can provide would be greatly appreciated. Thanks!