Solved

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

Posted on 2013-01-30
3
145 Views
Last Modified: 2013-02-15
to avoid its growing and not to reduce it.

To reduce it I know how to do

Thanks
0
Comment
Question by:hidrau
3 Comments
 
LVL 10

Assisted Solution

by:deviprasadg
deviprasadg earned 250 total points
ID: 38835083
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
 
LVL 19

Accepted Solution

by:
strivoli earned 250 total points
ID: 38835095
0
 
LVL 1

Author Closing Comment

by:hidrau
ID: 38892762
thanks
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question