hmmm..i think i should leave the way it is. Thanks for analysing.

Well the first one is dedicated one and the second one where is moved the files also has different LDF's on the same LUN.

i think 5 spindles..but both the LUNS are exactly the same..

no worries...i figured it out. Permissions were missing. Thanks

thanks SQL Guru, i did some analysis on IO stalls but the result is very weird. There are equal number of reads and writes done on tempdb on a RAID...

thanks..i am assuming when u specify size it does for initialization and also to set max size right?

this is strange, when i use my query i get a message to restart sql server and when i use yours it just does it dynamically without starting the...

Is this the correct sql? I am trying to initialize filesize of mdf with 100 mb and ldf with l0 mb and max size for mdf and ldf would be...

Got it. Attaching create table scripts.

sounds good..

can someone point me to an article which states this? thanks

thanks...did anyone look at the script and see if it helps? many of our processes are highly dependent on tempdb and currently we have temdb data and log file...

thanks guys.

thanks..but i am still lost...i do not have any space issues..my only concerned is i should be able to make a decision that moving tempdb log file to another drive...

hmmm ok....i think in sql 2008 we can uninstall SP right?