Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 155
  • Last Modified:

my tempdb is getting very large, is there any way to avoid this?

to avoid its growing and not to reduce it.

To reduce it I know how to do

Thanks
0
hidrau
Asked:
hidrau
2 Solutions
 
deviprasadgCommented:
TempDB is used by SQL Server for many internal operations, It can grow in size.

Refer:
http://serverfault.com/questions/241372/sql-server-tempdb-size-seems-large-is-this-normal

To reduce it you need to shrink database.
0
 
hidrauAuthor Commented:
thanks
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now