Errrrrr... made the fillfactor low on the heavy insert tables. Seems to be a lot of those in this database. Heavy page splits as well as bad execution...

After clearing the cache plans things seem to be going back to normal this week. Used Steve Jones's suggestions.. prioritized longest running jobs that the developers said needed to...

Have never used DTA. Have any good suggestions for setting this up and are the results easy to read? Sorry..nore of an Oracle DBA .. SQL Server is...

Also, there are many jobs that will truncate tables or even some DTS jobs will say "DELETE" rather than truncate. Then once this is done new inserts are being...

Performance was already pretty bad So I just Ended up doing a DBCC FreeProcCache statement and DBCC DROPCLEANBUFFERS of course some customers were complaining about their queries taking even longer...