Header Ads

Monitoring Tools for SQL Server

I explain about monitoring tools for SQL Server.Now a days lots of monitoring tools available for internet.Here I have listed out some of best monitoring tools.


SQLNexus is developed by Bart Duncan and Ken Henderson tool that simplifies SQLDIAG using, firstly by providing a configuration file for SQLDIAG and scripts for additional information from Dynamic Management Views and then storing the output in a database, and providing comprehensive Reporting Services to analyze results.You can download here


SQLDIAG is an executable is installed with SQL Server, whose goal is to collect the maximum amount of information system, usually to send to Microsoft support teams. It recovers data from the system and SQL Server on demand (taking a snapshot) or continuously. It can be invoked from the command line, or installed as a service. It is able to recover information from SQL Server instances in cluster.He recorded his results in text files in a specific directory. It can be configured from the command line or through a configuration file. It can recover Windows performance logs, SQL traces, Windows event logs, configuration information of the system and SQL Server, blocking information sessions, etc.. This is an extremely useful tool for diagnosing problems.

Log Parser

Log Parser is not specifically for SQL Server. This is a very powerful tool for reading, research and reporting that works on all types of log files (log files, XML, CSV) and the Windows event logs, registry, etc.. You can read, search with a query language like SQL, format the result in text or HTML, and even generate graphs. You can download Log Parser here. A free GUI Rights was created by a programmer, you can find it here

Windows Sysinternals

The Sysinternals tools developed by Mark Russinovich (a recognized expert
of meandering Windows) and Bryce Cogswell, are available on the Microsoft website, since Winternals, Russinovich company, was acquired in 2006.You will find at the adress technet.microsoft.com/en- us / sysinternals / tools needed, easy to use system diagnostics. Among them:
• DiskMon: trace disk activity.
• Process Monitor: Displays at real-time business processes and threads, of
the registry and disk activities.
• Process Explorer: Displays in detailed process activity: handles, DLL
used, open files, etc.. Very useful for going into detail.
• TCPView: displays in real-time TCP and UDP open ports.

No comments:

Powered by Blogger.