Hello nick,
thanx for your guidance.
in our prod set up we have nearly 8 biztlak nodes each node have around 6 host instances connecting to a
clustered sql box.The sql box is quad core and having 16 gb ram. we have alloted 4 gb(custom size)
for VM paging file. the sql server is awe enabled and the box was booted with /pae option.
coming back to the problem, we detected very HIgh PF usage. In the task manager, it was consistenly on over 14
gb.
When we restarted Sql service,the PF usage came back to normal range around 1 gb and processing was very quick.
But everytime we process a
large inbound file via Biztalk, the PF usage on SQl seems to rise. After the processing, it does not seem
to come down.However CPU/PF usage on the 8 biztlak nodes are normal.
any ideas?