September 17, 2018 at 9:11 pm
Comments posted to this topic are about the item Monitoring Costs
September 18, 2018 at 3:27 am
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 🙂
September 18, 2018 at 8:24 am
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
September 18, 2018 at 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?
Kindest Regards, Rod Connect with me on LinkedIn.
September 18, 2018 at 12:51 pm
Rod at work - Tuesday, September 18, 2018 9:20 AMNow 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.
September 19, 2018 at 8:14 am
miapjp - Tuesday, September 18, 2018 12:51 PMRod at work - Tuesday, September 18, 2018 9:20 AMNow 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.
September 19, 2018 at 8:22 am
Rod at work - Tuesday, September 18, 2018 9:20 AMNow 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.
September 19, 2018 at 9:20 am
Beatrix Kiddo - Wednesday, September 19, 2018 8:22 AMRod at work - Tuesday, September 18, 2018 9:20 AMNow 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 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply