Hi,
I have been recently been leant an Itanium 4way dual core server with 24MB
L3 Cache and 32GB of Ram. (Nice)
I am using the server for some performance testing but am unable push the
beast.
Setup.
Win2003 SP1
SQL 2005
We use Application Center to load balance. It is a 3 tier Application
Center
Cluster.
We have a front cluster which is used to load balance against a rear
cluster. We normally have 4 servers in the rear cluster then the DB server
at
the back.
Our appplication is threaded so we can define how many threads it uses to
process the workload. The idea being the more threads used the quicker the
job gets done. This works to a point of course.
For the tests I am doing, I have 6 servers in the rear cluster and have
really upped the threads and it seems to make no difference on the
performance.
Our application is written in Delphi and we use Com objects.
Things I have checked.
There is no blocking.
All machines in the rear cluster are active
No CPU, Memory or Disk constraints
Netowrk is not stressed
I wanted to know if anyone had experienced any bottleneck created by app
Center.
The number of transaction/sec in the main database seems to be very spikey
rather than consistent. The spike go from 1000 to 35. Where as in TempDB
the
Transaction/sec is fairly consistent at 110.
The active transaction is consistently 8.
Does anyone have any suggestion to what the bottleneck might be or what
else
I could monitor?
Thanks in Advance
Jamie..
