Check Actual DB Size

Hi,
How do I check what is the actual DB size that is currently being use?
e.g. I set 10 GB as initial size. A few days and a few transactions later, how can I know how much was used since it is still under 10GB and checking the physical DB file will not tell me anything.If you are looking for SQL SERVER.
I think when u create it for the first time it creates a database of 2 GB.

If Enterprise Manager, select the Database name that you are looking for.
Right Click and check for Properties.

You get 2 Options : Size : 2 GB
Size Available : 0.98 GB.

Is this the Information that you are looking for|||ooh..okay..thanks...
But anybody can confirm that I just need to check from there?

I checked one of the db...the available size was 0.00mb but the Size is 40mb....this db was originally detach and ziped from Production enviroment and unziped then attached to Development.

Changing value of "Initial Size (MB)"

I would like to increase the initial size of a SQL 2005 DB from 150 to 250 GB to prevent automatic autogrowth; would this have any impact in production if you do it on the fly?
Thanks,
Carlosyes it will ... sql server has to prepare the additional dataspace before it can be used. Why don;t you wait until off hours or a maintenance window?|||we have an equallogic iSCSI SAN and a 64 bit quad processor server. How much downtime should I plan for?

Thanks|||I would test it and see but you should be measuring in minutes - a real finger in the air maybe 10 minutes - but I really don't know. You could also maybe try doing it a bit at a time in a loop with a WAITFOR pause. This would prolong the process but maybe give the server chance to catch up on queued processes.

A further, more sophisticated method, would be to have a regular job check the amount of unused space at your typical low usage time (assuming there is one) and have it grow it ~3-4 days worth of growth if the free space is below a specified amount. This is the sort of proactive sizing we do in our shop.