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 |
|
mark_b
Starting Member
24 Posts |
 Posted - 2007-08-20 : 10:50:11
|
| Quick question relating to the above tables.I am currently experiencing an issue where the syscomments and sysdepends tables are increasing exponentially.For example, i have a database with data segment of 666 MB (maybe its the number!) and the syscomments is 254MB and sysdepends is 325MB. all the other tables are remaining static, and over my sample period have not increased. Also there have been no new procedures or views created on this database, so I am not sure why these two tables are increasing so much.Does anyone have any ideas as to what is causing this? or have any pointers for things i should be checking?Many thanks in advance.Mark |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
mark_b
Starting Member
24 Posts |
Posted - 2007-08-20 : 11:26:00
|
| [code]sp_spaceused sysdepends gives :name rows reserved data index_size unusedsysdepends 153775 332880 KB 215176 KB 117640 KB 64 KB sp_spaceused syscomments gives :name rows reserved data index_size unusedsyscomments 6395 260296 KB 259416 KB 832 KB 48 KB [/code] Thanks for the tip on the formatting. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
syscomments / sysdepends