So i've been delegated to be a SQL Server DBA now (which I am perfectly content with), but im running into some issues and I am not sure how to proceed.

To make a long story short:

-installed a new server with SQL Server 2005 SP1. Has two databases on it.
-(2) arrays: 1st array is RAID 1 with some of the database and t-logs on it (I know..working to fix): 2nd array I just moved the tempdb.mdf file and tempdb.ldf files over this morning.

I was getting horrible I/O performance (to be expected) which prompted me to put in some more drives and move the tempdb files. This helped a bit, but now I am noticing some very funky things.

Over the last hour, i have seen my tempdb.mdf file grow from 10mb to almost 90gigs. I've been watching the performance on this machine, and the array with the tempdb is really seeing a lot of writes to it.

I am very very new to SQL server. Does anyone have some suggestions on profiiling and tracing I can do to see what is going on? Something in the Query analyzer?

I really appreciate it very much. This is new territory for me.

Thanks.