Post reply

Email the Auto-growth events that have occurred in the last 24 hours t

  • May 1, 2014 at 6:33 pm

    #306954

    Comments posted to this topic are about the item Email the Auto-growth events that have occurred in the last 24 hours t

  • May 14, 2014 at 5:41 am

    #1713413

    Thanks for sharing this script..

    Email does not coming if database file auto gowth disabled and pre-sized already..

    Is it correct?

  • September 11, 2014 at 5:25 am

    #1744704

    Thank you very much for a really helpful script!

  • September 11, 2014 at 10:40 am

    #1744861

    Hi Patrick,

    Great Script. With sys.fn_trace_gettable being deprecated and Extended Events recommended, I was wondering if you or anyone else has performed this function using Extended Events?

    Thanks,

    Gary

  • September 11, 2014 at 11:57 am

    #1744895

    Thanks for the comment. I am yet to update the script or create a new method using extended events.

    Once i do, i will share it as well.

    If you do find one, feel free to share it as well.

    🙂

  • September 11, 2014 at 1:23 pm

    #1744909

    Thanks. Will Do!

  • September 12, 2014 at 2:10 am

    #1744989

    Nice script!

    I wrote something similar, but with a different approach.

    My solution uses a central server for various checks and reports. One of these is on database usage: each night a script collects the defined sizes and the actual usage of all data and log devices of every database on a set of (linked) servers (using 'DBCC SHOWFILESTATS' and 'DBCC SQLPERF(LOGSPACE)').

    This records database space usage on all my SQL servers and allows me to report on database size history (for trending purposes).

    In addition, it uses the info recorded on a daily basis to email any changes in data or log device size (auto-growth or manual expansion).

    In case you're interested I can share the code.

  • September 12, 2014 at 7:09 am

    #1745069

    By all means, please do. That's what this forum is for.

    🙂

  • September 19, 2014 at 8:08 am

    #1746726

    akhamoshioke (9/12/2014)

    By all means, please do. That's what this forum is for.

    🙂

    I aim to rewrite my script in Powershell and submit that as an article in the near future.

  • September 19, 2014 at 1:01 pm

    #1746816

    As per your script email HTML Report not received for last 24 Hrs auto growth details. But executed successfully

    Does it means if database autogrowth disabled at database setting?

  • September 22, 2014 at 1:39 pm

    #1747226

    Hey There!

    Thanks for posting your findings;

    Let's gather some more info so we can help figure out why it didn't send the email.

    Then, execute the following statement in the msdb database to check the status of the mail queue:

    exec sysmail_help_queue_sp @queue_type = 'Mail' ;

    I am interested in the status of the messages. Please share that once you get it.

  • September 23, 2014 at 1:11 am

    #1747303

    Thanks for reply..

    exec sysmail_help_queue_sp @queue_type = 'Mail' ;

    state: INACTIVE..

    But I have recevied backup email alert and other alerts also...

  • March 8, 2016 at 8:24 am

    #1863719

    The auto growths for the log cause the VLF's, if you perform a large growth to the size it needs to be for workloads you will not incur a large number of VLF's.

  • March 9, 2016 at 6:50 am

    #1863982

    Great code. I am going to set this up on all of my high profile SQL Servers. Thanks.

  • March 10, 2016 at 4:42 pm

    #1864459

    Interesting script, thanks.

Viewing 15 posts - 1 through 14 (of 14 total)

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