Post reply

Data collection

  • November 22, 2010 at 1:15 am

    #388277

    Hi,

    I need to collect tempdb object creation rate and size of temp db every half hour…

    Collect the information for 2 weeks and then create my monitoring report.

    Is there any easy way to do this rather than noting it every half hour/day by using scripts..

    I cannot create any objects in my system.

    Thanks

  • November 22, 2010 at 1:19 am

    #1253609

    Create a SQL Agent job, schedule it every 30 min. If you don't have permission to create it, ask your DBA.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 22, 2010 at 1:23 am

    #1253611

    Sorry, we cant any jobs on the system.

    (coz creation one requires a big long chain of getting approvals from everybody and it would never be approved just for single report)

    Any other way, that stores the info

    (by the way i'm the DBA here 🙂 )

  • November 22, 2010 at 2:45 am

    #1253634

    There's nothing built-in that stores that.

    Why would a monitoring job not be approved? Surely management wants the servers monitored?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 22, 2010 at 2:49 am

    #1253635

    there exists monitoring by using some 3rd party tools (which are great).

    In addition a report is generated every 2 week to get short summary and inform management about stats and health.

    I know they would say, since this report is for very low priority, better do it manually..(which i hate)..

    such is the business!!!!

Viewing 5 posts - 1 through 4 (of 4 total)

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