I have being testing IDERA SQL Server Diagnostics Manager, in this blog I show you the basic steps to configure it to monitor a single SQL Server Instance. Idera SQL Server Diagnostic Managers offers an automated way to monitor your SQL Server Instances, after you install the software, you must follow this steps to configure it:

 

1. Add the SQL Server Instance to be monitored

image

 

image

image

2. You must configure what diagnostic information you want to collect

image

3. If you want to monitor queries change the configuration as follows

image

4. Click on start console

image

5. On the console you can view the critical queries

image

6. The query monitor can configure with thresholds

image

7.If you want the check the overall status of the server you can do it in the summary window

 

image

 

Regards,

Ing. Eduardo Castro Martínez, PhD – Microsoft SQL Server MVP

image image image image

http://mswindowscr.org

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

https://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

http://mswindowscr.org/blogs/sql/default.aspx

http://citicr.org/blogs/noticias/default.aspx

http://sqlserverpedia.blogspot.com/

Note: Cross posted from Eduardo Castro.

Permalink