Submit a ticketCall us

ebook60.pngHow to be a Cisco® ASA ace

Our eBook, Thou Shalt Not Pass…I Think?! can help you overcome the challenges of monitoring and managing Cisco ASA firewalls. This eBook is a great read if you’ve been frustrated with monitoring firewalls, managing ACL configs, and troubleshooting VPN connections.

Get your free eBook.

Home > Success Center > ipMonitor > ipMonitor - Knowledgebase Articles > Monitor the size of database in MS SQL

Monitor the size of database in MS SQL

Table of contents
No headers


Within the ADO-QA Monitor, you can use the following query:

select size as Number_of_8KB_chunks from [database_name].dbo.sysfiles;

***This will give you the number of 8 Kilobyte chunks for the data file ([database_name].mdf)and the transaction log ([database_name].ldf)

select size*8 as Size_in_KB_Each from [database_name].dbo.sysfiles;

***This will give you the number of Kilobytes used by the data file ([database_name].mdf) and the transaction log ([database_name].ldf)


select sum(size)*8 as Size_in_KB_Total from [database_name].dbo.sysfiles;

***This will give you the total Kilobytes used by the data file ([database_name].mdf) and the transaction log ([database_name].ldf) together.

Last modified

Tags

Classifications

Public