microsoft / microsoft/sqlmanagementobjects
Change SMO performance tracking from a compile time setting to a runtime setting
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 143
- Forks
- 28
- PR merge metrics
- No merged PRs in 30d
Description
SMO has several chunks of code tracking things like time to execute queries and the total number of queries run blocked off by #if INCLUDE_PERF_COUNT.
We could replace that ifdef with a factory of some sort that only measures and collects the data when an application initializes it or if an environment variable is set. It could log it using actual performance counters on Windows.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating the SMO code guarded by #if INCLUDE_PERF_COUNT and trace how that compile-time setting is configured. Review the surrounding query timing and query-count collection paths, then define the runtime initialization or environment-variable behavior and Windows counter integration; done means performance tracking can be enabled at runtime without the compile-time guard.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100