Comments (4)
Hi Gene,
The whole point of the empty catch block is to discard any errors like the one you're seeing:
This throw an error:
DBCC INPUTBUFFER(32767);
But this doesn't:
BEGIN TRY
DBCC INPUTBUFFER(32767);
END TRY;
BEGIN CATCH
END CATCH;
So it seems odd that it would still bubble up at all. Are you sure you've got this tracked down correctly?
Thanks!
from sp_whoisactive.
Hey Erik,
Thanks for the explanation on the CATCH. I get it. Most of the time the call works to log to the table. During the early morning hours we go through some heavy data loading and monitor for thread pool, disk latency etc.
But at the time of some of the failures/errors, we were sitting pretty. Batch requests down. Memory and CPU at baseline.
The only thing that would cause this error is the INPUTBUFFER call. Not sure why it surfaces but that seems like the cause inside sp_WhoIsActive.
We run it every 20 seconds so perhaps the DELETE is running when the next call starts. But the job should finish the INSERT and the DELETE and end solidly. Then the new iteration should start.
I am willing to take any suggestions to "track it down correctly"
I think maybe wrapping the call to log it in a transaction might help.
from sp_whoisactive.
Hi Gene,
Sorry for over-explaining. You seemed surprised by the empty catch block, so I figured I'd throw it out there.
This is a tough one to take on, because a lot of issues that get reported as bugs here come down to a variety of local factors that are impossible to reproduce outside of a particular user environment/setup.
If you come up with a code fix on your end that solves the problem, you can submit a PR for review. I don't have the bandwidth to either try to reproduce the issue, or make shot-in-the-dark code changes and await feedback.
Thanks,
Erik
from sp_whoisactive.
Yes I was indeed surprised. Thank you for that Erik. I understand completely. Thank you. I will see if I can solve it. Will submit a PR if I find an answer. Thank you.
from sp_whoisactive.
Related Issues (20)
- An error occurred while executing batch. Error message is: Name cannot begin with the '>' character, hexadecimal value 0x3E. Line 126, position 22. HOT 1
- @get_full_inner_text = 1 HOT 3
- Addition of Session level Wait stats
- Empty Results Set from sp_WhoIsActive HOT 1
- SQL Agent job no longer works with SQL 2022 HOT 4
- Scalability issue when >740K syslockinformation rows HOT 4
- Can't find a permission set to run sp_whoisactive on an Azure DB HOT 5
- 'Dormant' should be treated the same as 'sleeping'
- XML datatype instance has too many levels of nested nodes. Maximum allowed depth is 128 levels HOT 1
- Is @get_transaction_info = 1 accurate? HOT 1
- SQL 2019 errors HOT 1
- I am facing below warning once the execution is stopped for sp_whoisactive.. Should I be worried for the data due to this? HOT 1
- active_transaction_count > than reported on sys.dm_tran_active_transactions HOT 1
- Error Creating Procedure on Synapse Dedicated Sql Pool
- Add column to show object (stored procedure) name from dm_exec_sql_text HOT 2
- On index creation the IO doesn't return correct results
- add query_text_id column HOT 1
- Should new memory columns be divided by 8? HOT 2
- An error occurred while executing batch. Error message is: Name cannot begin with the ' ' character, hexadecimal values 0x20. Line 5372, position 60. HOT 10
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sp_whoisactive.