Temp db will grow with misuse of temp tables, Cross Joins, large queries, aggregates

Check for those using the profiler ...

check this thread out ... http://www.sqlservercentral.com/Forums/Topic910208-146-1.aspx

**UPDATE **

I checked the PRD server where the mails are still working and ran

execute_as_principal_id = 1 on sp_ExternalMailQueueListener and sp_sysmail_activate

On the QAS server

execute_as_principal_id = -2

and checked http://msdn.microsoft.com/en-us/library/ms187795.aspx

ID...

Database mail has stopped once again this morning ...

What can cause it to stop?

I ran

sysmail_start_sp

alter queue ExternalMailQueue with status = on

an I'm sending mails again ...

any leads?

MS SQL 2005 Standard Edition with SP2 x86

Microsoft Windows Server 2003 with SP2

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

what switches did you change in the boot.ini file?

3GB and PAE??

I'm asking because of your max and min memory settings above ...

why do you want to shrink the tempdb?

is the drive it is currently on running out of space? if this is the case move it to a larger drive ...

I would suggest you implement Gail's suggestions ...

change to bulk logged receovery model

implement reindex or reorganize index via a script depending on the fragmentation levels ...

and DO NOT SHRINK the...

thanks Paul 😀 will check on what backups are available and find out if they want a restore or accept the dataloss ...

issue with a user table ...

SELECT name, type_desc FROM sys.objects

WHERE object_id IN (738817694) returned HIP7_IPSEventParameterUSER_TABLE

thanks 😉 I thought as much

how often do you backup those db's?

what version of 2005 and what is the SP installed also???

bad indexes, statistics can also coz SQL cpu usage to go crazy ...

Did you run a sql trace to confirm that it is the bad sql statements in the program...

what step is failing in the maintenance job?

What other job is running while this 1 is failing?

what transaction job is running every 15min? Tlog backup?