Browse by Tags

DBCC EXTENTINFO - unused pages in these extents (undocumented)

Published 4 September 7 7:45 AM | SSQA.net

When it comes to resolving table fragmentation, the basic checkout you perform is to run DBCC INDEXDEFRAG or even run DBCC DBREINDEX statements. As per the default configuraiton SQL Database Engine allocates a new extent to an allocation unit only when...

Filed under: sql server, performance, indexes, data, i/o, table, insert, allocation, fragmentation, deadlock, extent

Is it possible to estimate the space requirement for TEMPDB or factors that are affecting space?

Published 12 July 7 3:16 AM | SSQA.net

No straight answer to say yes you need so and so value to set on TEMPDB for such space requriement. By default i t is difficult to estimate the tempdb space requirement for an application. In general and one of the best practice is to allow 20% more space...

Filed under: sql server, fillfactor, indexes, trace, alerts, trigger, usage, tempdb, allocation, requirement