<div>
Monitor when the size changes or when it's getting nearly full (so before it has to extend)?<br />
<br />
Can the dmv sys.dm_db_file_space_usage<wbr /> give you the info you want? And integrate that in &nbsp;a monitoring-report you already have.<br />
<a href="http://msdn.microsoft.com/en-us/library/ms174412(v=sql.90).aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms174412(v=sql.90).aspx</a><br />
<br />
Or alerts<br />
<a href="http://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/" rel="ugc">http://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/</a><br />
And look at the counters available if there is something that matches what you want.
</div>


Monitor when the size changes or when it's getting nearly full (so before it has to extend)?

Can the dmv sys.dm_db_file_space_usage give you the info you want? And integrate that in  a monitoring-report you already have.
http://msdn.microsoft.com/en-us/library/ms174412(v=sql.90).aspx [http://msdn.microsoft.com/en-us/library/ms174412(v=sql.90).aspx]

Or alerts
http://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/ [http://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/]
And look at the counters available if there is something that matches what you want.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
It is possoble to monitor and alert the size of ndf file in databases in sql 2005? I can see you can do it in SQL 2008.<br />
<br />
Thanks
</div>
</div>


Hi,

It is possoble to monitor and alert the size of ndf file in databases in sql 2005? I can see you can do it in SQL 2008.

Thanks

Monitoring data file facets for availble space in SQL 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.