Locate a SQL Connector Dataset based on Query Alone
Hello,
We are working with a server with some resource limitations and sometimes SQL Connector queries hitting the database at the wrong time will block other processes from running. All the database managers can give me when they ask me to identify which Domo SQL Connector dataset caused the problem is an ip address, the actual query, and the time the query started running.
My question is this: Is there a way for me to use Administrator tools or DomoStats to use the query to identify the SQL connector job? At the moment, I have to open all the SQL connect datasets' details (for the jobs I think are relevant) and compare their queries against the one I'm given. Sometimes the query is general enough that I can't even weed down the possible datasets too much nad I have to go through them one by one. The time the query started running only helps if the dataset actually finished running because I can look it up based on time, but in this case they killed it while it was running so I can't find it that way.
Thank you,
NSH
Any suggestions how I can use existing functionality to make the scavenger hunt easier?
Comments
-
Sorry, are you using web-based connectors or workbench to move the data?
If you're worried about blocking SQL Server, it might make sense to schedule exports from SQL Server as CSV files and then move the files into Domo via Workbench + CSV connector.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
I'm referring to the web-based SQL Server connector. Thank you, that's a good idea about the alternative connector, I will consider that after I find the culprit dataset.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive