the database growing

teodor76
teodor76 used Ask the Experts™
on
we have a database on the sql server 2005..this database is growing to max..We shrinked the db..there is %15 free on it..the growing is set to unlimeted growt with 1 mb setp..recovery model is simple..what is the problem?how can I solve this problem?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented:
do you have tables in the db with no clustered index ? yes : create clustered indexes on those tables
do you have open transactions open in the db? check DBCC OPENTRAN to see if there are any
do you have some process that is inserting into the db/tables which you are not aware of?

Author

Commented:
I have checked somethings that you say so no open transaction and no some process that inserting into the db / tables which are no aware of because there is quato..I think that only remained reason is indexes..how can I find  no clustered index and how can I do them as clustered indexes? if I change indexes from no clustered indexes to clustered indexes, do this proces cause any problem? other question how can 1 find the max size of this database?
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
> if I change indexes from no clustered indexes to clustered indexes, do this proces cause any problem?
no.

>how can I find  no clustered index
if you use the sql management studio, check on the design of the table, and click the indexes button, each index is either clustered or non-clustered (you can only have 1 clustered index per table)

>other question how can 1 find the max size of this database?
what do you understand with "max size" ?


Author

Commented:
thanks Angell..1 would like to know  is there the max.size for my database? because of it always growing..to make clustered index, can the growing of the database be blocked?
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
unless you have a express editions (with 4GB max size), the size is only limited by the file system and the os capacity.
if the database grows a lot, you should consider to implement filegroups, have dedicated filegroups for "hot" tables, dedicated filegroups for hot indexes etc...
you can also create multiple files for a single filegroup, to keep the size of a single file down (=> for backup/restore optimizations)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial