InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 04:25:08 GMT20http://www.sqlservercentral.com/Forums/Topic1381400-1365-1.aspxSorry that I'm a little late to the party but this was an excellent article to help me get this monitoring setup in our environment. It has already helped tremendously.With that said, I was wondering if anyone has tried to capture more data than just what is in the article? In particular, I am looking the "Filename" column that is part of the DATA FILE AUTO GROW EVENT CLASS. According to tall of the documentation I can find, this is supposed to be the logical file name of the file being extended. Whenever I try to retrieve it, I get nothing.Using the code similar to that in the article, I try to pull the Filename using the following:@FileName = @message_body.value('(/EVENT_INSTANCE/Filename)[1]', 'varchar(500)')This is not a problem for most databases but I came across a database today that fired this event and when I went to look at the files to make the appropriate changes, I found that it had several data files. I have no way of knowing which file grew.Thanks!Mon, 11 Feb 2013 13:54:50 GMThawghttp://www.sqlservercentral.com/Forums/Topic1381400-1365-1.aspxAnother one for the briefcase, this knowledge makes the life of the Prod DBA a lot easier! :satisfied:Thank you.[i][b]qh[/b][/i]Sat, 29 Dec 2012 11:07:51 GMTquackhandle1975http://www.sqlservercentral.com/Forums/Topic1381400-1365-1.aspxNice article.Mon, 24 Dec 2012 12:23:20 GMTNeha05http://www.sqlservercentral.com/Forums/Topic1381400-1365-1.aspxis the duration in milliseconds?. very interesting article!! bravo!Mon, 12 Nov 2012 03:09:37 GMTsugnu iuhttp://www.sqlservercentral.com/Forums/Topic1381400-1365-1.aspx[quote][b]Jonathan Kehayias (11/6/2012)[/b][hr]Comments posted to this topic are about the item [B]&lt;A HREF="/articles/autogrowth/93229/"&gt;Tracking Database File AutoGrowth with Event Notifications&lt;/A&gt;[/B][/quote]Jonathan,Tested the routine, not that I had doubts but had to follow the protocol in the environment of course, and like it very much.Now, I have 2 methods for monitoring.awesome..Wed, 07 Nov 2012 12:39:41 GMTJohn Esraelo-498130http://www.sqlservercentral.com/Forums/Topic1381400-1365-1.aspxVery informative and well written Jonathon. Your articles are always spot on and a true value.ThanksCarlWed, 07 Nov 2012 10:49:31 GMTCarlDemelohttp://www.sqlservercentral.com/Forums/Topic1381400-1365-1.aspxHi Johnathan,I have been using a method that once I found on internet if now here at sqlservercentral and has helped me identifying certain elements and information on one or more DBs in my environment and notifying me via the DBMail separately .. &lt;code&gt;ALTER PROCEDURE [dbo].[USP_CollectDBInformation_Display] @DBName nvarchar(32) = '_N/A'ASBEGIN SET NOCOUNT ON; select servername, databasename, sum(filesizemb) as FilesizeMB, [Status], RecoveryMode, sum(FreeSpaceMB)as FreeSpaceMB, sum(freespacemb)*100/sum(filesizemb) as FreeSpacePct, InputDate, year(InputDate) TheYear, month(InputDate) TheMonth, day(InputDate) TheDay, datepart(qq, InputDate) TheQuarter from dbinformation where filesizemb &gt; 0 and databasename like case @DBName when '_N/A' then '%%' else '%' + @DBName + '%' end group by servername,databasename, [Status], RecoveryMode, InputDateEND&lt;/code&gt;and then the email of course&lt;code&gt;Exec msdb.dbo.sp_send_dbmail @profile_name = 'LocalServer' ,@recipients = 'JohnE.sql@gmail.com' ,@query = ' your statement goes here ' ,@Subject = 'DB Information' ,@Attach_query_result_as_file = 1;&lt;/code&gt;Albeit, I like your method and definitely going to examine it in my test environment and I know that I am going to like it.. well done!Tue, 06 Nov 2012 13:11:28 GMTJohn Esraelo-498130http://www.sqlservercentral.com/Forums/Topic1381400-1365-1.aspxGreat article, Jonathan.For alerting and recording all auto grow of your databases, that is the way to go.Just for the record, if readers are saving [b]default trace files[/b]: they also capture db growth information. Downside of using these trace files: you may miss one/some if the 20MB size is bering reached before your checking interval and they roll forward before you were able to copy them.( and of course profiler being depricated ... )Tue, 06 Nov 2012 01:27:23 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic1381400-1365-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/autogrowth/93229/">Tracking Database File AutoGrowth with Event Notifications</A>[/B]Tue, 06 Nov 2012 00:01:42 GMTJonathan Kehayias