Monitoring Costs

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714297

    Comments posted to this topic are about the item Monitoring Costs

  • DinoRS

    SSCrazy

    Points: 2278

    I just wish the Management DWH shipped with SQL Server would be a bit less complicated to add your own metrics to it, most insightful tool you can have to see how Execution Plans etc. change over time - free of charge 🙂

  • MattF

    SSCrazy

    Points: 2280

    We use SQL Data Collections extensively - there are some script examples available such as this custom collection set but I agree it could be simpler.

  • Rod at work

    SSC-Dedicated

    Points: 33069

    Now that I work for an organization that is highly segregated ("IT Ops is over there; you sit here"), I'd like to see how what I work on as a developer, is effecting the system. Normally, I never know. Unless someone from Ops comes over and claims that something I work on is now a resource hog. Otherwise, we've kept in the dark.

    Is that the way it is in large organizations?

    Kindest Regards, Rod Connect with me on LinkedIn.

  • miapjp

    Right there with Babe

    Points: 761

    Rod at work - Tuesday, September 18, 2018 9:20 AM

    Now that I work for an organization that is highly segregated ("IT Ops is over there; you sit here"), I'd like to see how what I work on as a developer, is effecting the system. Normally, I never know. Unless someone from Ops comes over and claims that something I work on is now a resource hog. Otherwise, we've kept in the dark.

    Is that the way it is in large organizations?

    When I worked in a semi-large org, it was pretty much like that.  You couldn't be testing your queries and looking at execution plans (or whatever they are in Oracle, I forget) in prod.  
    Count your blessings, though.  I'm jealous.  I'd like to muck around in data all day and create reports for users, and instead the one user who actually used metrics and asked for reports and apps left.  I spent all Sunday trying to get the phone system back up.  Ugh.

  • Rod at work

    SSC-Dedicated

    Points: 33069

    miapjp - Tuesday, September 18, 2018 12:51 PM

    Rod at work - Tuesday, September 18, 2018 9:20 AM

    Now that I work for an organization that is highly segregated ("IT Ops is over there; you sit here"), I'd like to see how what I work on as a developer, is effecting the system. Normally, I never know. Unless someone from Ops comes over and claims that something I work on is now a resource hog. Otherwise, we've kept in the dark.

    Is that the way it is in large organizations?

    When I worked in a semi-large org, it was pretty much like that.  You couldn't be testing your queries and looking at execution plans (or whatever they are in Oracle, I forget) in prod.  
    Count your blessings, though.  I'm jealous.  I'd like to muck around in data all day and create reports for users, and instead the one user who actually used metrics and asked for reports and apps left.  I spent all Sunday trying to get the phone system back up.  Ugh.

    Ouch! I don't envy you.

    Kindest Regards, Rod Connect with me on LinkedIn.

  • Beatrix Kiddo

    SSC-Dedicated

    Points: 32332

    Rod at work - Tuesday, September 18, 2018 9:20 AM

    Now that I work for an organization that is highly segregated ("IT Ops is over there; you sit here"), I'd like to see how what I work on as a developer, is effecting the system. Normally, I never know. Unless someone from Ops comes over and claims that something I work on is now a resource hog. Otherwise, we've kept in the dark.

    Is that the way it is in large organizations?

    It has been in previous places where I've worked. You couldn't even get a Windows sysadmin to come and troubleshoot an issue with you. It was with them OR the DBAs; not both. Utterly maddening.

    Where I am now, somebody has rolled out a server operating tool that hasn't been configured for SQL servers at all, so I keep being asked "urgent" questions based on them glancing at one isolated performance counter and freaking out.

  • Rod at work

    SSC-Dedicated

    Points: 33069

    Beatrix Kiddo - Wednesday, September 19, 2018 8:22 AM

    Rod at work - Tuesday, September 18, 2018 9:20 AM

    Now that I work for an organization that is highly segregated ("IT Ops is over there; you sit here"), I'd like to see how what I work on as a developer, is effecting the system. Normally, I never know. Unless someone from Ops comes over and claims that something I work on is now a resource hog. Otherwise, we've kept in the dark.

    Is that the way it is in large organizations?

    It has been in previous places where I've worked. You couldn't even get a Windows sysadmin to come and troubleshoot an issue with you. It was with them OR the DBAs; not both. Utterly maddening.

    Where I am now, somebody has rolled out a server operating tool that hasn't been configured for SQL servers at all, so I keep being asked "urgent" questions based on them glancing at one isolated performance counter and freaking out.

    Ouch! Nasty. Sorry to hear that.

    Kindest Regards, Rod Connect with me on LinkedIn.

Viewing 8 posts - 1 through 8 (of 8 total)

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