Help with Tempdb - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Help with Tempdb

Author

Topic

thecoffeeguy
Yak Posting Veteran

98 Posts

Posted - 2008-01-22 : 17:30:04

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.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-01-22 : 17:55:47

Restarting the SQL service will created new TEMPDB.but it is not recommended practice. Google it.