We have a SQL Server DB that is filled with records from two external applications that have the ability to execute queries against this DB. Both apps are black boxes for us, we don't have access to the code. We would like to know each execution of these queries from which application it is called. We have detected when and how often the queries are executed thanks to the Query Store, but we do not know the origin of each execution. Is there any way to find out?
How to detect the origin of a query execution in SQL Server?
505 views Asked by AceBetho At
0
There are 0 answers
Related Questions in SQL-SERVER
- Dynamic query creation with Array like implementation
- 'pyodbc.Cursor' object has no attribute 'callproc', mssql with django
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- PHP Laravel SQLServer could not find driver
- Upsert huge amount of data by EFCore.BulkExtensions
- How to locate relevant tables or columns in a SQL Server database
- Cannot delete SQL datafile (.mdf) as its currently in use
- Writing query in CTE returning the wrong output
- Group By Sum and without Group by sum Amount is different
- plan_handle is always different for each query in SQL Server Cache
- Adding a different string to a table fails
- The specified data type in the EF modelBuilder doesn't correspond to the one that is created
- SQL71561: SqlComputedColumn: When column selected
- How to Solve Error Associated with Trusted Authority
- SQL Server Data Model and Insert Performance
Related Questions in SQL-EXECUTION-PLAN
- plan_handle is always different for each query in SQL Server Cache
- Stored Procedure Taking very Long to execute
- What does Type "ref|filter" mean in mariaDB Explain Output
- Select query takes too long to execute
- PostgreSQL Hash Join vs Nested Loop and hash index
- How do I test the performance of an SQL query with parameters in SSMS?
- Performance Issues After Migrating from MariaDB 10.3.39 to 10.6.16 Due to Changes in Query Execution Plan
- Exact meaning of actual times in PostgreSQL explain analyze
- How to improve sort performance in a huge dataset of 20 million rows?
- PostgreSQL query plans when using unnest() in SELECT list vs in subquery
- Postgres nested loop not used in recursive query
- Terrible performance joining a view to a fast subquery / CTE in PostgreSQL
- SQL Server restart/large database restore impacting stored procedure unexpectedly
- Efficient many-to-many embedding comparisons
- Two identical MariaDB slaves, two different execution plans
Related Questions in SQL-QUERY-STORE
- max query store size in sql database getting reverted
- How can we see when query store in SQL Server 2016 was turned ON and OFF?
- How to avoid multiple value after joining three tables in SQL Server?
- Delete from SQL Server 2017 QueryStore dmv issue
- Postgres SQL equivalent of SQL Server for distinct values with all columns
- Count rows with specific data only, excluding data if it has another record with different details in another column
- Extracting string values from a column into different columns
- SQL Query works but it takes too much time to complete
- SQL in databricks query bug
- Getting totals from tables related to a parent table - SQL
- Param Stale Query Threshold (Days) doesn't work on QueryStore, SQL Server 2019
- Concatenate query output
- How to use LIKE operator in MYSQL?
- SQL Query to compare two columns with one column equal to a column in another table and second column is not equal to the second column from t2
- CASE STATEMENT last date of the month or max date of the month EOMONTH and MAXDate
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)