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.