Can some one let me know those basic steps of how to add a MS Sql database to monitor using solar wind ? I need to monitor table spaces and status etc ... of the database.
Hello,it depends on what exactly you need to monitor. There are prepared templates for SQL 2005 and 2008 that provide you some basic SQL server statistics. You can add your database to monitoring by following steps:
If you need more information about your database, you can create a new template and use "SQL User Experience Monitor" to execute custom SQL queries to get custom data. Add more those monitors to one template to get multiple values about your database.
You can find more information about templates and how to use them in our Administrator Guide on http://www.solarwinds.com/support/apm/docs/APMAdministratorGuide.pdf
Thanks Tomek ...I'll try this and see ..