Solved

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

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

679 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