SELECT count(idorder), sum(value), avg(value), GROUP_CONCAT(customer SEPARATOR ', ') from test.orderįor more detailed information on this example, please see the following post in our knowledge base: Ģ. You can execute a query with SQL sensors to extract and monitor the following information from your online store's database: number of one-off orders, total number of orders, average order value, and names of customers. Several different manufacturers, including Oracle and Microsoft, use SQL for their databases.ġ. Queries are performed with SQL to process database information. SQL (structured query language) is a database language. SQL monitoring: definition, examples, uses, costs
MS SQL: Microsoft SQL Server 2005 or laterįind out more about setting up a database monitoring scenario with SQL server sensors in our online manual.SQL Server Monitoring with PRTG can be used with the following SQL server versions:
