SQL Server Performance Forum – Threads Archive

Size of Temp DB

Hi all,
in my systen size of the tempdb is growing about 4.5 GB … how to resolve the problem ? ————–
Hemant Goswami
[email protected] hsGoswami

The tempdb database can be used directly via Transact-SQL, for example, as when temp tables are used; or it can be used indirectly, like it when ORDER BYs or GROUP BYs are run as part of a query. Check these links for further information:
http://www.sql-server-performance.com/tempdb.asp
http://www.support.microsoft.com/?id=307487 Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Or just stop and restart SQL. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>