473,385 Members | 2,274 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

SQL Automatic Growth

We use SQL 2000 and our database is configured to grow automatically by
10%. Currently 96% of our database is used. At what point will the
database expand - what is the trigger point?

Jul 23 '05 #1
2 1306

"jlgreg36" <jl****@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
We use SQL 2000 and our database is configured to grow automatically by
10%. Currently 96% of our database is used. At what point will the
database expand - what is the trigger point?
When it's full.

Which can be a problem.

Let's say your DB is 10 GB in size and it's full and you attempt to do an
insert.

The insert will be blocked until SQL Server allocates 1 GB of disk space
which can take some time.

(Now imagine a 100GB DB that tries to allocate 10 GB of disk space. :)

Generally you're better off monitoring it yourself and allocating space as
required. Or at the very least allocate fixed amounts of diskspace so you
don't get into a geometrically increasing amount of time for each
allocation.


Jul 23 '05 #2
Greg D. Moore (Strider) (mo****************@greenms.com) writes:
"jlgreg36" <jl****@hotmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
We use SQL 2000 and our database is configured to grow automatically by
10%. Currently 96% of our database is used. At what point will the
database expand - what is the trigger point?
When it's full.


More precisely, where there are no more free extents, and SQL Server
needs a new extent. At this point, there is still some free space
available in the database, although this is only of academic interest.
Generally you're better off monitoring it yourself and allocating space as
required. Or at the very least allocate fixed amounts of diskspace so you
don't get into a geometrically increasing amount of time for each
allocation.


Completely agree!
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Dave Serrano | last post by:
I have a question about altering tables and growth of the database and transaction log. I have a database which is approximately 35GB. I had to make a change to a column in the largest table...
10
by: Generic Usenet Account | last post by:
I have worked out a very simple method for tracking the "memory growth" of a process at run time. It involves a header file and a shell script. Here's the header file: ////////// Header File...
6
by: masri999 | last post by:
Hello, I need to monitor every 15 minutes growth in data file and log file . Since mdf and intial file sizes are set to high value, measuring these values at 15 min interval will not provide the...
0
by: Thomas F.O'Connell | last post by:
Matthew, Here's some more feedback on our use of pg_autovaccum. It's clear that it's working and that it's helping, but even after increasing our max_fsm_pages substantially (to in excess of...
18
by: junky_fellow | last post by:
Hi all, Is there any way by which we mat determine the direction of stack growth (from higher address to lower address Or from lower address to higher address) ? I know this question is...
3
by: myjish18 | last post by:
Hello, We have a DB2 UDB database v8.2.7 (db2 v8.2 fixpak 14) on AIX 5.3 which has Automatic Storage (AS) enabled. We want to disable automatic storage on entire database and/or disable...
6
by: Angel Tsankov | last post by:
Hi, I remember reading in a book (or in an article) that the optmial buffer growth factor is about 1.6. Now I need to find this book but I can't remember its title. Can someone help me with this?
25
by: sidd | last post by:
In the following code: int i = 5; ---it goes to .data segment int j; ---it goes to bss segment int main() { int c; int i = 5; ---stack
2
by: disco990 | last post by:
Hello everyone! I have an assignment in my Java class to gauge and compare the "order of growth" of two different sections of code. Below is the actual assignment: "The following code...
9
by: vanlanjl | last post by:
Okay this is very complicated (for me), but i need some help on this please. I am creating a Network Diagram in Visio, along with this I have collected all the Information for every Network Device...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.