Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anarayanamoorthy
Starting Member
15 Posts |
 Posted - 2011-02-23 : 12:21:13
|
| Hi,I'm using Microsoft SQL Server 2005 Enterprise Edition installed in live server where the TempDB is reaching the size to 15GB and making the disk space low. I have restarted the sql services and after 20 mins of start its slowly increasing its size. There is no job agent or sproc running at backend. TempDb is under simple recovery mode and I have set the growth rate to 10GB but it breaking it and reaching 15GB. What needs to be done in this case.Narayanamoorthy A |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
anarayanamoorthy
Starting Member
15 Posts |
Posted - 2011-02-24 : 00:20:10
|
NO there are not much temp tables in TempDb but i have a lot of temp tables in other database for my application. Can you let me know how to determine exactly wht queries are running inder tempdb. The isolation level is read committed. quote:
Originally posted by tkizer
You need to determine what queries are using tempdb. Do you have a lot of temp tables or table variables? What about sorts? Are you using read committed snapshot isolation level?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Narayanamoorthy A |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2011-02-24 : 09:26:04
|
tempdb can also grow to enormous size if you have someone doing a large bulk import with no batchsize specified, because then the entire import is committed as a single transaction. have you done any large bulk imports using bcp or BULK INSERT lately?
elsasoft.org |
|
|
|
anarayanamoorthy
Starting Member
15 Posts |
Posted - 2011-02-25 : 05:57:02
|
| No no bulk imports and inserts has been taken place.Narayanamoorthy A |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-02-25 : 11:42:43
|
| In Re: "NO there are not much temp tables in TempDb but i have a lot of temp tables in other database"All temp tables reside in the TempDB database regardless of which database you are using them from.=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
|
|
|
|
|
|
TempDB Size Issue