# SQL statistics for Amazon RDS for SQL Server
<a name="USER_PerfInsights.UsingDashboard.AnalyzeDBLoad.AdditionalMetrics.SQLServer"></a>

Amazon RDS for SQL Server collects SQL statistics both at the statement and digest level. At the statement level, the ID column represents the value of `sql_handle`. At the digest level, the ID column shows the value of `query_hash`. 

SQL Server returns NULL values for `query_hash` for a few statements. For example, ALTER INDEX, CHECKPOINT, UPDATE STATISTICS, COMMIT TRANSACTION, FETCH NEXT FROM Cursor, and a few INSERT statements, SELECT @<variable>, conditional statements, and executable stored procedures. In this case, the `sql_handle` value is displayed as the ID at the digest level for that statement. 

**Topics**
+ [Per-second statistics for SQL Server](#USER_PerfInsights.UsingDashboard.AnalyzeDBLoad.AdditionalMetrics.SQLServer.per-second)
+ [Per-call statistics for SQL Server](#USER_PerfInsights.UsingDashboard.AnalyzeDBLoad.AdditionalMetrics.SQLServer.per-call)
+ [Primary statistics for SQL Server](#USER_PerfInsights.UsingDashboard.AnalyzeDBLoad.AdditionalMetrics.SQLServer.primary)

## Per-second statistics for SQL Server
<a name="USER_PerfInsights.UsingDashboard.AnalyzeDBLoad.AdditionalMetrics.SQLServer.per-second"></a>

The following metrics provide per-second statistics for a SQL Server SQL query.


| Metric | Unit | 
| --- | --- | 
| db.sql.stats.execution\$1count\$1per\$1sec | Number of executions per second | 
| db.sql.stats.total\$1elapsed\$1time\$1per\$1sec | Total elapsed time per second | 
| db.sql.stats.total\$1rows\$1per\$1sec | Total rows processed per second | 
| db.sql.stats.total\$1logical\$1reads\$1per\$1sec | Total logical reads per second | 
| db.sql.stats.total\$1logical\$1writes\$1per\$1sec | Total logical writes per second | 
| db.sql.stats.total\$1physical\$1reads\$1per\$1sec | Total physical reads per second | 
| db.sql.stats.total\$1worker\$1time\$1per\$1sec | Total CPU time (in ms) | 

The following metrics provide per-second statistics for a SQL Server SQL digest query.


| Metric | Unit | 
| --- | --- | 
| db.sql\$1tokenized.stats.execution\$1count\$1per\$1sec | Number of execution per second | 
| db.sql\$1tokenized.stats.total\$1elapsed\$1time\$1per\$1sec | Total elapsed time per second | 
| db.sql\$1tokenized.stats.total\$1rows\$1per\$1sec | Total rows processed per second | 
| db.sql\$1tokenized.stats.total\$1logical\$1reads\$1per\$1sec | Total logical reads per second | 
| db.sql\$1tokenized.stats.total\$1logical\$1writes\$1per\$1sec | Total logical writes per second | 
| db.sql\$1tokenized.stats.total\$1physical\$1reads\$1per\$1sec | Total physical reads per second | 
| db.sql\$1tokenized.stats.total\$1worker\$1time\$1per\$1sec | Total CPU time (in ms) | 

## Per-call statistics for SQL Server
<a name="USER_PerfInsights.UsingDashboard.AnalyzeDBLoad.AdditionalMetrics.SQLServer.per-call"></a>

The following metrics provide per-call statistics for a SQL Server SQL statement.


| Metric | Unit | 
| --- | --- | 
| db.sql.stats.total\$1elapsed\$1time\$1per\$1call | Total elapsed time per execution (in ms) | 
| db.sql.stats.total\$1rows\$1per\$1call | Total rows processed per execution | 
| db.sql.stats.total\$1logical\$1reads\$1per\$1call | Total logical reads per execution | 
| db.sql.stats.total\$1logical\$1writes\$1per\$1call | Total logical writes per execution | 
| db.sql.stats.total\$1physical\$1reads\$1per\$1call | Total physical reads per execution | 
| db.sql.stats.total\$1worker\$1time\$1per\$1call | Total CPU time per execution (in ms) | 

The following metrics provide per-call statistics for a SQL Server SQL digest query.


| Metric | Unit | 
| --- | --- | 
| db.sql\$1tokenized.stats.total\$1elapsed\$1time\$1per\$1call | Total elapsed time per execution | 
| db.sql\$1tokenized.stats.total\$1rows\$1per\$1call | Total rows processed per execution | 
| db.sql\$1tokenized.stats.total\$1logical\$1reads\$1per\$1call | Total logical reads per execution | 
| db.sql\$1tokenized.stats.total\$1logical\$1writes\$1per\$1call | Total logical writes per execution | 
| db.sql\$1tokenized.stats.total\$1physical\$1reads\$1per\$1call | Total physical reads per execution  | 
| db.sql\$1tokenized.stats.total\$1worker\$1time\$1per\$1call | Total CPU time per execution (in ms) | 

## Primary statistics for SQL Server
<a name="USER_PerfInsights.UsingDashboard.AnalyzeDBLoad.AdditionalMetrics.SQLServer.primary"></a>

The following metrics provide primary statistics for a SQL Server SQL query.


| Metric | Unit | 
| --- | --- | 
| db.sql.stats.execution\$1count | Number of executions | 
| db.sql.stats.total\$1elapsed\$1time | Total elapsed time (in ms) | 
| db.sql.stats.total\$1rows | Total rows processed | 
| db.sql.stats.total\$1logical\$1reads | Total logical reads | 
| db.sql.stats.total\$1logical\$1writes | Total logical writes | 
| db.sql.stats.total\$1physical\$1reads | Total physical reads | 
| db.sql.stats.total\$1worker\$1time | Total CPU time (in ms) | 

The following metrics provide primary statistics for a SQL Server SQL digest query.


| Metric | Unit | 
| --- | --- | 
| db.sql\$1tokenized.stats.execution\$1count | Number of execution | 
| db.sql\$1tokenized.stats.total\$1elapsed\$1time | Total elapsed time (in ms) | 
| db.sql\$1tokenized.stats.total\$1rows | Total rows processed | 
| db.sql\$1tokenized.stats.total\$1logical\$1reads | Total logical reads | 
| db.sql\$1tokenized.stats.total\$1logical\$1writes | Total logical writes | 
| db.sql\$1tokenized.stats.total\$1physical\$1reads | Total physical reads | 
| db.sql\$1tokenized.stats.total\$1worker\$1time | Total CPU time (in ms) |