Improve company productivity with a Business Account.Sign Up

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

What activity that cause tempdb grow

Hi,
What is the activity causing the tempdb grow?? as I know creating index is one of them
0
motioneye
Asked:
motioneye
4 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
-temp tables , table variables
-GROUP BY / ORDER BY operations
- Index creations
- DBCC commands
0
 
imran_fastCommented:
Creating index.
Bulk Insert
Update statement updating huge number of records.
Creation of temparary # tables.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<-temp tables , table variables
-GROUP BY / ORDER BY operations
- Index creations
- DBCC commands >>

You may add to the above
--> Row Versionning
--> Complex calculations

Hope this helps...
0
 
motioneyeAuthor Commented:
what is that mean by Row Versionning?
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
<<what is that mean by Row Versionning?>>In SQL 2005, MS has implemented ORACLE's read consistency that allows to make sure that at any time the user gets access the last commited version of the data.  That prevents from having users waiting for an update transaction to be committed before they can actually make a select.  To implement that functionnality, SQL Server now perpetually keeps updated the last commited version of data in tempdb.  As a result, tempdb gets a big hit in terms of IO's because it supports all select's instead of the original tables.  It is one of the factors that may strongly influence the growth of temdb.

Hope this helps...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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