SQL monitoring Tools | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL monitoring Tools

Does anyone have any recommendations for sql monitoring tools? (either free or purchase) we currently don’t have an for our SQL 2K server and would like to get something that can alert us when a variety of things bottleneck, error out, whatever. also like to be able to look at the connections, speed flow of queries etc. anything that you’ve tried and liked would be appreciated. Mike L. Warner
Check the tools from Quest , Idera, red-gate and sql sentry etc…
Just google these comany names you will find log…but you need to buy them… and also check the following…
SQL Server Software Spotlights
http://www.sql-server-performance.com/spotlights.asp MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

REd-gate does not have monitoring tool. most of their tools are for developments.
I think SQL Sentry has a good tool.
http://www.sql-server-performance.com/software_spotlights/da_sql_sentry_3.asp there is another tool from idera callare diagnostic manager
http://www.sql-server-performance.com/sql_dm_idera_review.asp —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

I would like to know why you want to go towards third party tools, is there any specific need or report you need to produce. You can take help of PERFMON & traces to get such information. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Could you please tell me how to use Performance Monitor & Trace to monitor performance problem issue of a production server. Thanks
or you can use profiler and Windows PerfMon AKTHAR
you need to:
1 – Go to Adminitrative tools – in Performance Monitor – add necessary counters- e.g Memory – pages /sec commited bytes, available bytes to monitor memory performances
Add processor counters
Add SQL server locks and other required SQL Server counters
2. In SQL Server profiler – choose events you want to log, like locks, transactions etc. http://www.sql-server-performance.com/performance_monitoring_tutor_part4.asp AKTHAR
Refer to the homepage of this SSP site and go through the articles section where you will find complete details in this regard.
http://www.sql-server-performance.com/sg_sql_server_performance_article.asp – a starter
quote:Originally posted by tfakih Could you please tell me how to use Performance Monitor & Trace to monitor performance problem issue of a production server. Thanks

Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>