New to SQL Server 2005: Help with tempdb
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.