SQL Server, Advanced Analytics object

Applies to: SQL Server

The SQLServer:Advanced Analytics object in SQL Server provides counters to monitor the actions associated with executing some analytical syntax.

This table describes the SQL Server Advanced Analytics counters.

SQL Server Advanced Analytics counters	Description
Predictions/sec	Number of predictions performed using PREDICT function.

Examples

You begin to explore the query performance counters in this object using this T-SQL query on the sys.dm_os_performance_counters dynamic management view:

SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%Advanced Analytics%';

Related content

• Native scoring using the PREDICT T-SQL function with SQL machine learning
• Monitor Resource Usage (Performance Monitor)