Counter - Data File(s) Size (KB)

Question

Post reply

Counter - Data File(s) Size (KB)

SQL Galaxy

One Orange Chip

Points: 29472
More actions
December 24, 2010 at 3:27 am

#229887

Hi,
5400.00 MB total space
4073.31 MB used space
1325.79 MB free space
I want raise alert when free space become 250 MB.
How much value enter in value colum and rais above
Name - Datafile
Type - SQL server performance condition alert
Object - SQLSERVER:database
Counter - Data File(s) Size (KB)
Instance - DBName
After if counter - raise above
Value -
Thanks for your help
ananda

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 1

Database Size is - 5406 MB

Database free size - 1314 MB

I created new alert thru

Set the type as SQL server performance condition alert.

Choose SQL server: DATABASEs from OBJECT drop down box.

Choose datafile size(kb) from counter

Choose the databasename from instance drop down box.

Then enter value (in 500 KB) as thershold limit .

Response time ever 5 mint.

I want receive alert when database size reach 500 MB of database free size 1314 MB.

But received mail as bleow at every 5 mints.

DESCRIPTION:The SQL Server performance counter 'Data File(s) Size (KB)' (instance 'RILEBS') of object 'SQLServer:Databases' is now above the threshold of 500.00 (the current value is 5529600.00).

As per this mail alert, counter name always checking total value of database size, but its not checking database freespace.

please tell me, how to modify thershold value by free size database?

Thanks for your help.

ananda

Sven Otromke SSC Enthusiast Points: 135 More actions · Answer 2

Hi,

I am not sure if such a counter exists. Instead you could use a WMI event alert. Write a little script that queries sp_spaceused or DBCC showfilestats. That should do the job. There are some similar scripts in the scripts section.

Regards,

Sven