high cpu usage for "Process Files" step, other options?
I have noticed that the "process files" step is a very cpu intensive operation. It causes 89%-100% cpu (2.8 Ghz Xeon processor).
Typically I am recursively searching subfolders for *.sql (in one folder there are over 600 stored procedures that I process)
I was wondering
1) is anyone else seeing this behaviour and is it normal
2) are there any other options besides writing my own code or scripts to improve performance?
Thanks.
|