gwillhight

Comments

  • Ah, ok i get what you mean. The database specific counters you want are stored in the same system database views as the overall counters. You'll need to add a line to the query to get the database you're looking into. for example the query for Log Flushes/sec is: DECLARE @time1 DATETIME; DECLARE @time2 DATETIME; DECLARE…
  • The "SQL Server 2005-2008 Performance (SQL)" template has the ability to monitor DB performance by instance. Once you've assigned the template to a server you'll need to go through the assigned template and set the instance you want to monitor under each of the components you want to monitor. I ended up making a copy of…
  • The only issue with topology i've found on my Cisco 6513 and 6504 (both sup 720) is that if the node on the other end isn't monitored by SNMP it won't tell you the interface on the connected node. I have several ESX hosts connected to both switches with CDP and SNMP enabled and a few without SNMP but with CDP still enabled…
  • You should only have to apply this to the web servers that you are trying to edit the templates from.
  • I had a similar issues with a couple of my 3750x switches after my upgrade. For the 3750x switches the hardware monitor looks to be pulling the power supply status from CISCO-ENVMON-MIB. the table at OID 1.3.6.1.4.1.9.9.13.1.5 contains the status of all power supplies in the stack. Using the MIB Browser in the engineer…
  • The change to the web.config corrected the problem and I did not get the error when I made the needed changes to the templates I was working with. Much appreciated!
  • SAM has the ability to monitor SQL database instances individually, and has a template that you could customize to monitor a single database within that instance. SQL Server 2005-2008 (SQL) is one such template. You can also create a custom monitor for specific processes running on a server. when you create a new monitor…
  • When i did my initial install I had to log in as a local admin and disable the UAC, so you might want to give that a shot also.
  • You should be able to use this process with no issues. I have done this a couple of times myself and had no problems. I did have to update which polling engine was monitoring the nodes, but if you're using the same IP, you may not have to do this. If you have any Custom Pollers you will want to take a copy of them and move…
  • * Other than troubleshooting, how do you make use of your flow data?* My group is in the middle of an enterprise wide network refresh so we're using flow data for both troubleshooting and for capacity planning. It has proven to be invaluable in that capacity when we are trying to justify upgrading WAN circuits * How often…
  • In the Advanced Alert Manager you'll need to create a Custom SQL Alert trigger. I use the trigger Query "Node" and the following SQL statement for triggering and alert on additions. Inner Join Events on Nodes.NodeID = Events.NetworkNode where EventType = 8 and Acknowledged = 0 The EventType of 8 is node added and EventType…