Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > ipMonitor > 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
21:40, 11 Oct 2015

Tags

Classifications

Public