Comments (1)
Hi @sumabris
those warnings provide you with hints that you should be aware of in case the data is wrong or the query takes a long time.
Warning: The join order has been enforced because a local join hint is used.
is printed because some JOINs are hinted, for example INNER LOOP JOIN
instead of INNER JOIN
. Normally you do not need those hints, sometimes they are in fact necessary to provide a fast or stable execution.
Warning: Null value is eliminated by an aggregate or other SET operation
is printed usually because of the usage of aggregation functions such as SUM
or AVG
on columns that contain NULL
values. NULL
are not processed.
If you want to get rid of the last warning, you can add SET ANSI_WARNINGS OFF
before executing the procedure.
I see no reason to be worried.
from sp_whoisactive.
Related Issues (20)
- 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
- 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
- Invalid SPID nnn specified when logging to a table 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
- active_transaction_count > than reported on sys.dm_tran_active_transactions HOT 1
- Intermittent error HOT 1
- Has this repo become Archived/in Maintenance mode? HOT 1
- Sql Server 2022 Support? HOT 6
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.