Thank you Jeff

Ok i got it and how do i check for memory leaks ?

The servers have 16 GB of RAM and run on 2 4 core CPUs.

The AWE is...

The size of the log file has never exceeded the 500 MBs , for tempdb,.

Now for the job itself.

The thing is that when the job is running and we come...

Hi Jeff

Actually the size has never grown above 4 Gbs for this db.

Also i have found the script which was used to modify its size.

i am attaching it here.

The shared...

The size of the db was limited to 8 GB with the log file to increase by 512 MB and the data file for 2048 MBs

Thank you Jeff for your reply.

I assume that you mean it is not a very good practice to change the auto grow setting to percent.

So shall i leave the tempdb...