hi all m having an issue ...
we are having a server contains 28 gb ram ... 20 gb given to sqlserver ,x64 enterprise ,windows 2003
database size 5 GB
we are having an application which goes 100 stages ....
all the stages are same which runs a proc ...
for every 1 stage took 5 mins after 35 stages the time increased and after 70 stages it is taking 35 mins wen i 1st checked the counters
total target memory and Target server Memory wer same and
then after stage 35 total target memory was less then Target server Memory
disk IO is not increasing as it was increasing cpu utilization is normal 14 %
buffer cache hit ratio is 99.20 and cache hit ratio is avg 55 % for 35 the stages after 35 it increased to more than 70 %.
wen using who2 active it shows cpu 463781 disk IO 406
Please provide me the solution i m not getin what exactly the reason is...