Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

TempDB questions Expand / Collapse
Author
Message
Posted Friday, February 22, 2013 10:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, February 23, 2013 5:20 AM
Points: 17, Visits: 273
I looked at this right at the end of this answer and in the specific test I did 250 pages seemed to be a magic number.

I'm not claiming this will always be the case though.
Post #1423149
Posted Friday, February 22, 2013 10:24 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 17, 2014 3:21 PM
Points: 185, Visits: 917
Thanks, Gail. It makes much more sense now.


Alex Suprun
Post #1423158
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse