January 1, 2013 at 9:40 pm
In general, would adding more memory reduce the growth of the tempdb during general operations of SQL Server?
January 1, 2013 at 11:56 pm
From MSDN
In a heavily loaded system under memory pressure, queries with merge join, sort and bitmap in the query plan can drop the bitmap when the queries do not get the minimum required memory for the bitmap. This can affect the query performance and if the sorting process can not fit in memory, it can increase the usage of worktables in tempdb database, causing tempdb to grow. To resolve this problem add physical memory or tune the queries to use a different and faster query plan.
see this link Optimizing tempdb Performance
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 2, 2013 at 2:19 am
Maybe. Depends why TempDB's growing.
If it's due to hash and sort spille, adding memory may help (optimising queries may help more). If it's due to temp tables and table variables, more memory won't help the TempDB size.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply