Check the database free space on a ms sql server

All questions related to installations, configurations and maintenance of Advanced Host Monitor (including additional tools such as RMA for Windows, RMA Manager, Web Servie, RCC).
Post Reply
frbo
Posts: 6
Joined: Thu May 28, 2009 2:09 am

Check the database free space on a ms sql server

Post by frbo »

I would like to know wath the free space is of a database on my sql server. Is ther a possibility to check that with ks-host?

Thanks

Frederik
KS-Soft Europe
Posts: 2832
Joined: Tue May 16, 2006 4:41 am
Contact:

Re: Check the database free space on a ms sql server

Post by KS-Soft Europe »

frbo wrote:I would like to know wath the free space is of a database on my sql server. Is ther a possibility to check that with ks-host?

Thanks

Frederik
Frederik,

You can do this with Host Monitor ODBC Query test.
http://www.ks-soft.net/hostmon.eng/tests.htm#odbc

According to MySQL 5.1 Reference Manual the query should look like
select sum(data_free) from INFORMATION_SCHEMA.PARTITIONS - for all the data files or
select sum(data_free) from INFORMATION_SCHEMA.PARTITIONS where table_schema = 'schemaname' for certain schema only.

Regards,
Tom
frbo
Posts: 6
Joined: Thu May 28, 2009 2:09 am

Post by frbo »

thanks
Post Reply