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 |
|
Prash7shinde
Starting Member
2 Posts |
 Posted - 2011-03-04 : 02:11:06
|
| In our Databs,Their only one master Table and 250 tables r connected to that master table.Only master table contains Pri.Kye. So we r doing Indexing daily for fast performace. SOme day before database size is 10 gb and now it is 50 gb . and i m able to find out the problem that why data base size incresing fastly. and even i m not able find out logical connection between the table.Thanks & RegardsPrashant Shinde.. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-03-04 : 08:36:09
|
| Did you shrink the database at any point of time ?PBUH |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-04 : 09:49:15
|
| If you're not shrinking the database, my suspicion is you are reindexing too frequently, especially tables that may not need it. You may only need to update statistics to maintain performance levels. Unless you have high recurring index fragmentation, you should avoid index rebuilds, and look more closely at your tables and indexes as they may not be designed properly.Tara (tkizer) has an excellent index defragmenting/maintenance script: http://weblogs.sqlteam.com/tarad/archive/2009/11/03/DefragmentingRebuilding-Indexes-in-SQL-Server-2005-and-2008Again.aspxShe also has a database size tracking script here: http://weblogs.sqlteam.com/tarad/archive/2010/07/09/Database-Growth-Tracker-Tool-ndash-New-Version.aspx |
|
|
|
Prash7shinde
Starting Member
2 Posts |
Posted - 2011-03-07 : 11:51:19
|
| i have done shriking and reindexing but the Database size is till incresing fastly and i m still not able to resolve the problem. Is Replicaton be the issue ? How can i analyse why database is incresing....Thanks &Prashant Shinde..[/quote]Thanks & RegardsPrashant Shinde.. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-03-07 : 15:40:43
|
| If the transaction log is increasing in size then back it up periodically, at least once an hour, preferably every 15 minutes. This will help prevent it from growing. You can shrink the log files after a backup, but DO NOT shrink the data files, you'll fragment the database.Also, do not use the maintenance plan wizard to perform these actions. Look up BACKUP LOG and DBCC SHRINKFILE in Books Online and run the appropriate statements manually. If you have a maintenance plan that does these actions, or performs a REINDEX, turn it off until you can do the manual log backup and log file shrink. |
|
|
|
|
|
|
|
|
Incresing Database Size