Add more SQL Server performance metrics

[samiura]

Component(s)

receiver/sqlserver

Describe the issue you're reporting

Added more performance metrics with the existing query. These metrics were already fetched with the existing query but are not registered as metrics. This issue will bring all these metrics which are already scraped as of now but not registered.

• sqlserver.active.temp.tables
  

• sqlserver.backup_or_restore
  

• sqlserver.replica_sent
  

• sqlserver.replica_received
  

• sqlserver.execution_errors
  

• sqlserver.free_list_stalls
  

• sqlserver.free_space_tempdb
  

• sqlserver.full_scans
  

• sqlserver.index_searches:
  

• sqlserver.lock_timeouts:
  

• sqlserver.logins
  

• sqlserver.logouts
  

• sqlserver.deadlocks:
  

• sqlserver.mirror_write_transaction:
  

• sqlserver.memory_grants_pending:
  

• sqlserver.page_lookups:
  

• sqlserver.transaction_delays:
  

• sqlserver.used_memory
  

• sqlserver.version_store_size
  

[github-actions]

Pinging code owners:

• receiver/sqlserver: @StefanKurek

See Adding Labels via Comments if you do not have permissions to add labels yourself.

[samiura]

Please note a PR is already prepared to tackle this issue. Not looking for anyone to work on this one.

[crobert-1]

Makes sense to me, we'll disable all of these metrics by default. Metric names can be discussed in the PR.

[github-actions]

This issue has been inactive for 60 days. It will be closed in 60 days if there is no activity. To ping code owners by adding a component label, see Adding Labels via Comments, or if you are unsure of which component this issue relates to, please ping @open-telemetry/collector-contrib-triagers. If this issue is still relevant, please ping the code owners or leave a comment explaining why it is still relevant. Otherwise, please close it.

Pinging code owners:

• receiver/sqlserverreceiver: @StefanKurek @sincejune @crobert-1

See Adding Labels via Comments if you do not have permissions to add labels yourself.

[crobert-1]

Resolved by #37883