Consumption statistics / Exporting Alert Settings
Has anyone had an issue with the consumption stats posted by the dev group being roughly 10x off in just about every category? One example "Total network traffic (inbound plus outbound) is 10 KB/sec per server." I am at a little over 100 kbps. Monitoring 2 servers with single instance on them. single AG running with one database on it. Here are the specs and setup:
Server - MS Server 2008 R2 Standard / SP1
Processor - Intel E5-2665 0 @ 2.40GHz - 2.40 GHz
Ram - 8GB
System Type - 64 bit OS
Base monitor and web ui installed on the same machine. I am monitoring 2 of these servers. The server contains a single availability group with one database that is very high volume OLTP. This is a re-installation where I am currently adding back all of the alerts slowly as it stands right now there are only 10 alerts on. (no AG alerts) No custom metrics.
AG Setup is as follows:
AG1 - db1 (read/write) -> db2 (read only) I still have 2 more production servers with about 30x more throughput to monitor that need to be added back ASAP. Can anyone tell me is there something i should or should not be doing? perhaps removing monitoring on the system databases (one or all) seems bad but is it common?
The second question if the above answer is yes, I will need to remove the AG and add it again, is there an easy way to export my current alert settings, and re add them after I re-add the server. I am currently getting memory pegging several times a day. very high latch waits, the longest running queries and highest consumption processes are coming from SQL Monitor. I need to be able to manage this and its very urgent. Any suggestions appreciated.
Dr. John Trumbul
skype : john.trumbul.jr
Backups? where we're going, we don't need any backups.