• Schadenfreude-Mei (5/5/2010)


    Thamizh (5/4/2010)


    Thank u all .I will try my best.In my work place we have Microsoft operations manager(SCOM) to monitor.But its irritating us because of popping lots of alerts and its takes huge memory of users machine.we cant follow that's y we planned to develop.can any one guide me to categorize only sensitive alerts like performance ,system etc.. the challenge is to incorporate the production servers in farms and club in to one server with low memory usage .

    Question: Everyone has been commenting as though you intend to go to market with a new product, the way i read this is that you just want to build an in-house monitoring tool.

    Which is it?

    If your not planning to develop (and then sell) a product, why do you not buy one? Idera DM is very good and is not too resource hungry.

    Otherwise if all you want is SQL stats, you can right an ssis to go across linked servers and bring back logs or run sp's to get out user, database, disk stats etc.

    That is true. I assumed, because you were talking right off about coding, that you wanted to build a comercial product. If you're just trying to build some internal monitoring tools, you should look at what's available for free from Microsoft, or simply look to leverage the same things through PowerShell or whatever coding language you like best.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning