Monitoring Costs

Question

Monitoring Costs

Steve Jones - SSC Editor

SSC Guru

Points: 736183
More actions
September 17, 2018 at 9:11 pm

#372800

Comments posted to this topic are about the item Monitoring Costs

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

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

DinoRS SSCrazy Points: 2683 More actions · Answer 1

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: 2285 More actions · Answer 2

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.

MattF

Rod at work SSC-Dedicated Points: 34007 More actions · Answer 3

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: 782 More actions · Answer 4

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: 34007 More actions · Answer 5

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: 32407 More actions · Answer 6

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: 34007 More actions · Answer 7

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.