Home → Support →

View the current size of a database?

• Edit

tansey

20 Feb, 2011 07:52 PM

Is there any way to view the current size of my application's database?

1. Support Staff 1 Posted by rune on 20 Feb, 2011 08:25 PM

   

   Hi,

   you could use sp_spaceused if you're on MsSql http://msdn.microsoft.com/en-us/library/ms188776.aspx .

   On MySQL you can use something like
   

   SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" 
   FROM information_schema.TABLES GROUP BY table_schema;
   

   We might integrate it in the frontend too!

   Best regards,
   Rune

   • Edit

2. rune closed this discussion on 20 Feb, 2011 08:25 PM.

3. tansey re-opened this discussion on 21 Feb, 2011 12:09 AM

4. 2 Posted by tansey on 21 Feb, 2011 12:09 AM

   

   Thanks Rune. I'm not familiar with MS SQL at all. How do I execute that command on my database?

   • Edit

5. Support Staff 3 Posted by rune on 21 Feb, 2011 07:01 AM

   

   Just like a regular query in SMSS - if you use that?

   • Edit

6. 4 Posted by tansey on 22 Feb, 2011 02:53 AM

   

   Got it, thanks Rune! That was the first time I've ever used SMSS actually.

   • Edit

7. tansey closed this discussion on 22 Feb, 2011 02:53 AM.