Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Build Usage connector for MSSQL #2905

Closed
harshach opened this issue Feb 21, 2022 · 0 comments · Fixed by #2948
Closed

Build Usage connector for MSSQL #2905

harshach opened this issue Feb 21, 2022 · 0 comments · Fixed by #2948
Assignees
Labels
enhancement New feature or request Ingestion P1 High priority

Comments

@harshach
Copy link
Collaborator

Is your feature request related to a problem? Please describe.
We currently support usage connector for Redshift, Snowflake, BigQuery only but MSSQL also supports fetching the queries from their tables

Describe the solution you'd like

FROM sys.dm_exec_cached_plans AS p
INNER JOIN sys.dm_exec_query_stats AS s
   ON p.plan_handle = s.plan_handle
CROSS APPLY sys.dm_exec_sql_text(p.plan_handle) AS t
ORDER BY s.last_execution_time DESC;

Use the above query to fetch all the sql queries and parse them through our query parser.

Describe alternatives you've considered

Additional context
Add any other context or screenshots about the feature request here.

@harshach harshach added enhancement New feature or request Ingestion labels Feb 21, 2022
@harshach harshach added this to the Milestone 4 - 0.9.0 Release milestone Feb 21, 2022
@harshach harshach added this to To do in Release 0.9.0 via automation Feb 21, 2022
@harshach harshach added the P1 High priority label Feb 22, 2022
@darth-coder00 darth-coder00 moved this from To do to In progress in Release 0.9.0 Feb 23, 2022
Release 0.9.0 automation moved this from In progress to Done Feb 23, 2022
ayush-shah pushed a commit that referenced this issue Feb 23, 2022
* Fix #2509: added mssql usage connector

* removed comment

* removed unused variables

* fixed code smell

* renamed sql variable
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request Ingestion P1 High priority
Projects
No open projects
Development

Successfully merging a pull request may close this issue.

2 participants