We have a vendor application with a database, 19 GB in size. The application also uses SSRS. Yesterday I received an alert that the tempDB on the SQL 2008 R2 server had grown over 5 GB in space. (The ReportServerTempDB is sized at 150 MB and has not grown.) It eventually reached 60 GB before I killed the process since it was going to soon use all the disk space available. The process was associated with the vendor application and when I spoke to the vendor they said that was normal and was due to SSRS. We're new to using SSRS so I was curious if this is normal? Should we anticipate tempDB growing that large and larger? Thanks
Steve