Submit a ticketCall us

WebinarDatabase Roundtable – Expert Database Professionals Feel Your Pain

In this video broadcast, Head Geek™ Tom LaRock is joined by Karen Lopez, Tim Chapman, and David Klee. They’ve known each other for many years, so this discussion was like four friends getting together to talk data and databases. They discussed diagnostic data collection, common performance root causes, reactive tuning versus proactive, and more. Join us for an engaging discussion on these topics! Plus, Tom LaRock will be available to answer your questions live.

Register now.

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