[Feature][Sort] Add new source metrics for sort-connector-sqlserver-cdc-v1.15

[PeterZh6]

Description

Parent Issue: #10961
Added source metrics in the same way as PostgreSQL-connector [Feature][Sort] Enhanced source metric instrumentation for InLong Sort Flink Connector #11129 for sqlserver-cdc-v1.15

Key Metric Categories:

1. Serialization/Deserialization Metrics:

   • Success/Error Counters: Track successful and failed deserialization attempts (numDeserializeSuccess, numDeserializeError).
   • Latency Gauges: Measure the time taken for both serialization and deserialization (deserializeTimeLag, serializeTimeLag).

2. SnapshotState Metrics:

   • Creation/Error Counters: Monitor the number of snapshots created and errors encountered during snapshot operations (numSnapshotCreate, numSnapshotError).

3. NotifyComplete Metrics:

   • Completed Snapshots Counter: Track the number of completed checkpoints (numCompletedSnapshots).
   • Snapshot-to-Checkpoint Latency: Record the time between snapshot creation and checkpoint completion (snapshotToCheckpointTimeLag).

Use case

No response

Are you willing to submit PR?

• Yes, I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct