krishnamohan6669 (1/7/2014)
Found that more MAX I/O Waittime is recorded with spotlight,so trying to increase the virtual file size. should wait and see wether this occurs again.
Jeff is proposing that you examine the perl script for optimisation opportunities. Having identified the perl script as the culprit, the cause of your problem, this would be the logical next step. Either it can be improved, or it cannot, and if it cannot, then you eliminate it from your list of entities to examine. Painting the rims of a broken-down car might make it look pretty but it wastes time and won't get you home.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden