1 - 3 of 3
PREVIOUS 1 NEXT
Controlling tempdb Growth
I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes. tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of the space...
I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes. tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of the space...
65 pts.
Estimate SQL Server tempdb space for a query
Database - MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge - about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns retrieved 2. Join...
Database - MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge - about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns retrieved 2. Join...
Where to place the tempdb log file?
I've heard it recommended to place the tempdb on its on own drive. Regarding the tempdb log file specifically, should it be on a different disk than the mdf or ndf files of the tempdb?
I've heard it recommended to place the tempdb on its on own drive. Regarding the tempdb log file specifically, should it be on a different disk than the mdf or ndf files of the tempdb?
1 - 3 of 3
PREVIOUS 1 NEXT
