MSSQL Database size graph

Brainli · Post by **Brainli** » Tue Apr 18, 2006 2:48 am

How can i create a Graph about the Database size of a Microsoft SQL 2000 Database?

Thank you very much.

Greets from switzerland.

BSOD2600 · Post by **BSOD2600** » Tue Apr 18, 2006 10:11 am

Is the data accssable via snmp? If not, then you'll probably have to write a WMI script. If it actually resides in one file, a small simple script which returns the filesize would work too.

Brainli · Post by **Brainli** » Tue Apr 18, 2006 10:38 am

Sorry but i don't know how to create a WMI Script. Do you have a little Manual for me?

btw:
The Cacti-Server is Linux and the Client (SQL-Server) is Windows.

Thank you very much.

BSOD2600 · Post by **BSOD2600** » Tue Apr 18, 2006 3:14 pm

Well first you need to figure out what will report the mssql database size. Then once you know that, then you can write the appropriate script.

fmangeant · Post by **fmangeant** » Wed Apr 19, 2006 1:53 am

Hi

I'm graphing MS SQL databases sizes; the results are fed into Cacti with NRPE. I'll post the script later today.

Brainli · Post by **Brainli** » Wed Apr 19, 2006 3:05 am

i have on a Windows-Server a ASP-Script with the Output:

Code: Select all

<html>
<body>
master 17344 KB<br>mastlog 2304 KB<br>
<br>
test_Data 1280 KB<br>test_Log 1024 KB<br>
<br>
MSDBData 13312 KB<br>MSDBLog 2304 KB<br>
</body>
</html>

Now i must this output to cacti script.. puhh..

Run this script from the Linux-Server on the Windows-Webserver and put the Output in a Graph..

BSOD2600 · Post by **BSOD2600** » Wed Apr 19, 2006 11:07 am

Alright, then you should take a read on how to make your script work with cacti. Then I also suggest you read this guide to get a basic idea how to create the data & graph templates for the script.

MSSQL Database size graph

MSSQL Database size graph

Who is online