How does SQL monitoring work as part of general server monitoring?
Server monitoring works as a general-purpose type of monitoring for these key pieces of hardware. Server monitoring may include looking at network traffic and issues like server availability, as well as server usage of resources like CPU and memory. Other types of server monitoring include tools for observing the deployment or handling of virtual machines in a virtualized network system, service and process monitoring, and even physical server monitoring for metrics like temperature and fan status.
|Webinar: Analyze and Optimize: A New Approach to Monitoring
Within server monitoring, SQL monitoring is the specific analysis of the Structured Query Language (SQL) used to perform so many requests for information from business servers. In SQL monitoring, administrators look at specific wait times, optimization and efficiency for sending and fulfilling SQL requests for information. For example, part of SQL monitoring may include looking at the most "expensive queries" for a system. These most expensive queries would be the types of SQL queries that would require the most system resources, because of the complexity of sifting through the information and returning results.
At Techopedia, we aim to provide insight and inspiration to IT professionals, technology decision-makers and anyone else who is proud to be called a geek. From defining complex tech jargon in our dictionary, to exploring the latest trend in our articles or providing in-depth coverage of a topic in our tutorials, our goal is to help you better understand technology - and, we hope, make better decisions as a result.Full Bio