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 |
|
sqlvijay
Starting Member
16 Posts |
 Posted - 2009-05-21 : 03:20:48
|
Hi Everybody I am new s qlserver.In my production database we using sql server 2005.Two months before my database SIZE is 11GB.within two months database size is gradually increased to 25GB.Hence the size differs daily by decreasing oneday and another day increasing eg: one day 25GB and another day 23GB and so on Can I have the initial capacity of MY databases set to 50GB and as and when it reaches 90% of the total size, can I auto-increment the size by 15%?my database data file auto growth has been set to 35%. Is it sufficient enough for the database to function properly?how can we calculate present database initial capacity? Is it possible to setup some initial capacity?and how can we set initial capacity?please onsite workers reported me the database Usage is very high . It is showing the red mark by using some tool for sql server . Can we set it something to 50G?please share your ideas and suggest the solution Thanks in Advance Vijay.S And sometimes by the time the database is trying to auto-increment, GIS Server is loosing some data.Can we fix this as soon as possible? |
|
|
|
|
|
Initial capacity of database in sql server 2005