12 Replies Latest reply: May 11, 2012 4:55 PM by aLTeReGo RSS

SQL Server User Experience Monitor - Server Name

PeterLyttle

Hello,

 

Following on from a previous post - APM Template for Textual Statistical Data?

 

I would like to request the ability to specify the server name to run the SQL query against.

 

For example I was creating a monitor for a Riverbed Steelhead (that used UnDP) I would have liked to apply this SQL check against the Steelhead node not the SQL server holding the data against it.  This way I can see if there is a problem with the Steelhead node and not the SQL Server that stores the data.

 

Cheers,

Peter

  • Re: SQL Server User Experience Monitor - Server Name
    aLTeReGo

    Instead of associating SQL queries with different hosts, wouldn't you rather a more comprehensive SNMP component monitor in SAM that supported similar functionally that the UnDP currently provides?

    • Re: SQL Server User Experience Monitor - Server Name
      PeterLyttle

      Oh definitely but I still can think of a place were we want to query our custom applications that are SQL driven.

       

      Eg has Application1 on ServerA updated some records for new users.

       

      Where ServerA connects to SQLA to store its data.  So the processing (updating of new users) is done by ServerA rather than the SQLA which where the Template would need to be applied

       

      Not sure if this makes sense, I hope it does.

      • Re: SQL Server User Experience Monitor - Server Name
        aLTeReGo

        Understood. I just wanted to be sure I understood the requirements of the feature request and that in your use case this did not simply satisfy a deficiency in the SNMP monitor, but had validity and usefulness beyond that requirement. I welcome others in the community who would also see value in such a feature to chime in as well and describe your use cases.

  • Re: SQL Server User Experience Monitor - Server Name
    netlogix

    I would also like this feature.  I have some common SQL servers that house multiple App's databases, so I have an app template that is for multiple apps on that sql server, but the services and processes are in another app template assigned to the app server.  I have worked out other ways to get things looking right, but this would give me more options.

    • Re: SQL Server User Experience Monitor - Server Name
      PeterLyttle

      Can you share your workaround to get the SAM/APM under the correct node?  I was thinking Powershell & WinRM might be able to do it or VBScript?

      • Re: SQL Server User Experience Monitor - Server Name
        aLTeReGo

        This was one of our primary uses cases for developing groups in Orion. Have you considered adding the node and the application into the same group and alerting and reporting upon the group instead the node and application separately?

        • Re: SQL Server User Experience Monitor - Server Name
          netlogix

          That is basically what I did - one group per application.  The biggest issue with that work around is that I can't put in a custom field for the primary technicians.  When it is assigned to the node, I can grab a node custom field, but with groups you get no way of using custom properties.  Now if groups had custom properties, that would fit the bill best.  One app that spans 5 servers, could be combined and you could have a shared/common SQL server that you pull specific components.  Then you would just need to setup views - can a group have custom views per group or type (?) of group.  It would be nice to have the view based on a custom property.

          • Re: SQL Server User Experience Monitor - Server Name
            aLTeReGo

            You are correct. It's not currently possible to create customized views for specific groups or create custom properties. These are some good feature request ideas that I'd recommend posting in the appropriate forum.

            • Re: SQL Server User Experience Monitor - Server Name
              netlogix

              are you saying these are not current feature requests?  I know I have seen custom properties for groups in many places, but that isn't for NPM/SAM/SeUM/NCM, it is more like Orion Core, is there a forum for that?  I want to use it for SAM, I don't even have to be an NPM user, and custom properties and views for groups would still be needed.  Does SAM not support the use of groups?  I guess I am just confused why an idea that would effect SAM does not belong in a SAM forum, is there a reason for this?

              • Re: SQL Server User Experience Monitor - Server Name
                aLTeReGo

                I'm sure both of these features have been requested by other customers already, but since I'm not the current Core/NPM Product Manager I can't say for certain how often this feature has been requested. I directed you to the NPM feature request forums because the NPM/Core product manager is moderates this forum. It also helps us funnel the demand for a particular feature or functionality related to core. Otherwise each Product Manager has a distorted view of how important a particular feature is to our customers. For example, if 1 IPAM customer would like to see custom properties for groups then the IPAM Product Manager probably thinks there isn't much demand for this feature. But if you add up all of the customers who think this is an important feature across all the different products then you might reach a different conclusion. Does that make sense?

                • Re: SQL Server User Experience Monitor - Server Name
                  netlogix

                  It does make since, but since this case is Core, and I thought Core was a collaborative effort or a team of it's own, I figured each PM should have it and be able to see how much demand there is for each product.  One thing that would be nice is to have is the ability to see and vote on the feature requests being tracked per category.  Then one could vote there or see that the idea isn't there then go make a request.

                  • Re: SQL Server User Experience Monitor - Server Name
                    aLTeReGo

                    We are kicking around some ideas to improve the Thwack feature request process that should help mitigate this issue. In this example all Orion products support groups so where do customers post feature enhancement requests? It doesn't make sense to post them in each product's respective forum since there's no easy way to gauge demand, and customers who don't own that specific product won't read those posts anyway to chime in. The only reason I directed you to the NPM feature request forum is because I believe that's where it will receive the highest level of visibility and the greatest number of customers willing to chime in. This also provides greater visibility to the Orion Core/Platform PM since he also happens to be the PM for NPM.

                     

                    What I should have done instead of directing you to the NPM feature request forum is provided a direct link to where I knew this request had already been made so you could add your input. At the moment however, I was headed into a meeting and couldn't find the Thread below.

                     

                    http://thwack.solarwinds.com/thread/42993