Site Admin - Deployment Planning and TEMP DB sizes. - SharePoint Management - SharePoint for All - Dell Community

Site Admin - Deployment Planning and TEMP DB sizes.

Site Admin - Deployment Planning and TEMP DB sizes.

This question has been answered by DELL-Richard Sch

 

(Posting on behalf of a customer)

Questions:

1. Is there some kind of ratio rule, or calculation that can be performed that will guide us upon how large our Temp DB should be "allowed to grow to"?  We have noticed that Site Admin seems to be inflating the Temp DB when large sites are searched.  It is 100gb now. 

2. Also, why would the Temp DB grow so large?  Is it a direct relation to the number of sites that are in use, or other factors?

(Note...after DBA research, it seems that Site Admin "is" what inflated the Temp DB).

 

Verified Answer
All Replies