Finding Database Size using sp_spaceused Stored Procedure

raj — Wed, 02 Jan 2008 14:33:00 GMT

We can use the sp_spaceused stored procedure to find out exactly how much disk space is currently being used by a database. If we simply execute this stored procedure without passing any parameters, it returns the following 2 result sets:

Result Set 1:

database_name: Name of the current database.
database_size: Size of the current database in megabytes. database_size includes both data and log files.
unallocated space: Space in the database that has not been reserved for database objects.

Result Set 2:

reserved: Total amount of space allocated by objects in the database.
data: Total amount of space used by data.
index_size: Total amount of space used by indexes.
unused: Total amount of space reserved for objects in the database, but not yet used.

code for etetnity !!! is hosted with GoDaddy Shared Hosting Plan which only allows upto 200 MB of database disk space which is really very limited and Community Server can reach this limit in no time. Therefore I have to keep monitoring the database disk space usage regularly. However, since GoDaddy does not provide Remote Desktop or Enterprise Manager / Management Studio access to the database server, the only way to know this is by executing the sp_spaceused stored procedure through GoDaddy's web based Query Analyzer or through a custom built ASP.NET web page which executes this stored procedure using ADO.NET. You can use the same technique if you face similar restrictions by your hosting provider.

For more info on the sp_spaceused stored procedure, click here.

Cheers,
Raj

~~~ CODING FOR ETERNITY !!! ~~~

Installing Community Server 2007 with GoDaddy Shared Hosting Plan

raj — Wed, 02 Jan 2008 12:12:00 GMT

Planning to launch a new Community Server 2007 website with GoDaddy Shared Hosting Plan? Or facing problems setting up the same? If you wish to save yourself all the hassles, download and read this excellent CS 2007 Installation Guide for GoDaddy Shared Hosting Plan by Dave Stokes here. I had a hard time setting up my CS 2007 website @ code for eternity !!!, but Dave's Installation Guide came to the rescue. Thanks for the excellent work Dave.

Cheers,
Raj

~~~ CODING FOR ETERNITY !!! ~~~

Technology : Community Server

Finding Database Size using sp_spaceused Stored Procedure

Installing Community Server 2007 with GoDaddy Shared Hosting Plan