tag:support.appharbor.com,2010-11-23:/discussions/problems/202-view-the-current-size-of-a-databaseAppHarbor: Discussion 2018-10-19T03:06:11Ztag:support.appharbor.com,2010-11-23:Comment/54721622011-02-20T20:25:02Z2011-02-20T20:25:32ZView the current size of a database?<div><p>Hi,</p>
<p>you could use <code>sp_spaceused</code> if you're on MsSql
<a href=
"http://msdn.microsoft.com/en-us/library/ms188776.aspx">http://msdn.microsoft.com/en-us/library/ms188776.aspx</a>
.</p>
<p>On MySQL you can use something like<br></p>
<pre>
<code>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;</code>
</pre>
<p>We might integrate it in the frontend too!</p>
<p>Best regards,<br>
Rune</p></div>runetag:support.appharbor.com,2010-11-23:Comment/54721622011-02-21T00:09:43Z2011-02-21T00:09:43ZView the current size of a database?<div><p>Thanks Rune. I'm not familiar with MS SQL at all. How do I
execute that command on my database?</p></div>tanseytag:support.appharbor.com,2010-11-23:Comment/54721622011-02-21T07:01:46Z2011-02-21T07:01:46ZView the current size of a database?<div><p>Just like a regular query in SMSS - if you use that?</p></div>runetag:support.appharbor.com,2010-11-23:Comment/54721622011-02-22T02:53:05Z2011-02-22T02:53:05ZView the current size of a database?<div><p>Got it, thanks Rune! That was the first time I've ever used SMSS
actually.</p></div>tansey