Solved

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

Posted on 2013-01-30
3
142 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

895 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now