Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
asqldeveloper
Starting Member
17 Posts |
 Posted - 2011-01-31 : 17:56:12
|
| HiWe have a clustered environment and the important database is mirrored. It is a highly transactional database. We also have a RO (Read Only) environment which is also clustered and use transactional replication to move data from Primary to RO's. With respect to availability, we are doing great. What we need pointers is, what other things we can do for Pro-Active monitoring and to show that we are doing a great job in system availability now and down the road, especially for management.We also have alerts for job failures, mirroring issues, replication issues etcSome reports we can think of is:1. Reindexing online where thats not happening now (we cannot afford more than 10 or 15 min downtime). 2. Capture performance counters3. Estimating DB size growth over a period so we increase size accordingly4. Server uptime over a period, so we show reliability and uptime over a period5. we developed a replication latency report which shows our SLA for the past day with respect to replication betn primary and RO's.The goal is to pro actively monitor for greater uptime and stability and also to show management in a quantifiable fashion of our achievements. Any help is appreciated. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2011-02-01 : 10:33:03
|
| Here is What We do Proactively monitor:1) Index Analysis Report2) Disk Alerts3) Performance Analysis of Server(Counters) with graphical representation.4) DB Size Growth Report. |
 |
|
|
|
|
|
Pro-active sql monitoring