Submit a ticketCall us

AnnouncementsSystem Monitoring for Dummies

Tired of monitoring failures disrupting the system, application, and service? Learn the key monitoring concepts needed to help you create sophisticated monitoring and alerting strategies that can help you save time and money. Read the eBook.

Get your free eBook.

Home > Success Center > ipMonitor > ipMonitor - Knowledgebase Articles > Monitor the SQL Server database size using ipMonitor

Monitor the SQL Server database size using ipMonitor

Updated October 3, 2018

Overview

This article provides examples of queries you can run in ipMonitor using the ADO-QA monitor.

Environment

All ipMonitor versions

Details

In 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 kb chunks for the data file ([database_name].mdf)and the transaction log ([database_name].ldf).

Specific queries

To return the number of kilobytes used by the data file ([database_name].mdf) and the transaction log ([database_name].ldf), use the following query:

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

To return the total kilobytes used by the data file ([database_name].mdf) and the transaction log ([database_name].ldf) together, use the following query:

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

Tags

Classifications

Public