Hi, All!
Today I worked on crazy SCOM monitor to allow IT operations care about SQL Server database fragmentation level. Unfortunately SQL Server 2008 R2 MP still doesn'y provide any index or table monitoring. And the key issue for me was a correct and usable user scenario:
- what is a real critical situation which need attention of IT operation?
- what is expected reaction of IT operation for information about some high-fragmented indexes in some large tables? just go to fix it? or escalate it to DBA?
- how often this check should be performed (it looks like that it's not too variative metric :) )
...and on, and on, and on... questions! And I want to point that I've found product which could be used as a solution pettern here. It's Idera's SQL defrag manager - standalone application which provide powerful and detailed analisys and maintanence for SQL Server databases - first of all in fragmentation context! 14-days trial is available and I'm going to download it and try to evaluate the expected user scenario - may be it will be really good! :)
