GilaMonster (9/21/2012)
Larger growth increments (fixed MB), grow TempDB manually, ensure there's enough space on the drive, tune the queries to use less TempDB.
Growth size is 8KB and 10% on the other.. I actually dont know what they are.. My question is do I have to change them??
Grow tempdb manually? are there any steps to do it?
Enough space on the drive -- There is like 40GB on the drive.
queries are using Left joins on XML and I will try to optimize too, before that any other suggestions on the above listed.
Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.