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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2006-05-15 : 16:17:45
|
| sp_spaceusedrow in one table went from 800 rows to 313156Format DBCC SHOWCONTIG scanning 'Z_ET_LK29' table...Table: 'Z_ET_LK29' (1600112841); index ID: 0, database ID: 5TABLE level scan performed.- Pages Scanned................................: 6- Extents Scanned..............................: 5- Extent Switches..............................: 4- Avg. Pages per Extent........................: 1.2- Scan Density [Best Count:Actual Count].......: 20.00% [1:5]- Extent Scan Fragmentation ...................: 80.00%- Avg. Bytes Free per Page.....................: 672.0- Avg. Page Density (full).....................: 91.70%DBCC execution completed. If DBCC printed error messages, contact your system administrator.Is there a way to determine how much that 31 thousand records would have caused the database size to grew.Can i determine this.Our database grew 1 1/2 gig over night normally its only 100 mg so now im looking at table growth |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-15 : 16:21:50
|
| Errmmm ... there are 6 data pages in this table, are you sure its holding 313,156 rows?Kristen |
 |
|
|
|
|
|
rows of data