Mixing
sp_WhoIsActive vs sp_BlitzFirst @ExpertMode = 1
Clash Royale CLAN TAG#URR8PPP
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;
up vote
2
down vote
favorite
I use sp_WhoIsActive and sp_BlitzFirst (with ExpertMode paramter set to 1) to get an overview of what is happening on the SQL Server in real time. I find these to be an upgrade on sp_who, sp_who2 etc...
Can anyone explain what, if any difference there is between the two. They seem to show the same thing, albeit with a slightly different set of columns. Also, BlitzFirst shows some other information in it's output as a separate output table
In this video, Brent shows his triage process in which he uses both sp_WhoIsActive and sp_BlitzFirst which makes me think there must be some difference but unless I missed something in the video I can't see why sp_WhoIsActive is required
sql-server troubleshooting sp-blitzfirst sp-whoisactive
asked 4 hours ago
SEarle1986
332213
add a comment |Â
up vote
2
down vote
favorite
I use sp_WhoIsActive and sp_BlitzFirst (with ExpertMode paramter set to 1) to get an overview of what is happening on the SQL Server in real time. I find these to be an upgrade on sp_who, sp_who2 etc...
Can anyone explain what, if any difference there is between the two. They seem to show the same thing, albeit with a slightly different set of columns. Also, BlitzFirst shows some other information in it's output as a separate output table
In this video, Brent shows his triage process in which he uses both sp_WhoIsActive and sp_BlitzFirst which makes me think there must be some difference but unless I missed something in the video I can't see why sp_WhoIsActive is required
sql-server troubleshooting sp-blitzfirst sp-whoisactive
asked 4 hours ago
SEarle1986
332213
iirc, i think it's sp_BlitzWho that is more like sp_WhoIsActive
– Rich Benner
4 hours ago
It looks like BlitzWho is the first output table in BlitzFirst @ExpertMode = 1
– SEarle1986
2 hours ago
add a comment |Â
up vote
2
down vote
favorite
up vote
2
down vote
favorite
I use sp_WhoIsActive and sp_BlitzFirst (with ExpertMode paramter set to 1) to get an overview of what is happening on the SQL Server in real time. I find these to be an upgrade on sp_who, sp_who2 etc...
Can anyone explain what, if any difference there is between the two. They seem to show the same thing, albeit with a slightly different set of columns. Also, BlitzFirst shows some other information in it's output as a separate output table
In this video, Brent shows his triage process in which he uses both sp_WhoIsActive and sp_BlitzFirst which makes me think there must be some difference but unless I missed something in the video I can't see why sp_WhoIsActive is required
sql-server troubleshooting sp-blitzfirst sp-whoisactive
asked 4 hours ago
SEarle1986
332213
I use sp_WhoIsActive and sp_BlitzFirst (with ExpertMode paramter set to 1) to get an overview of what is happening on the SQL Server in real time. I find these to be an upgrade on sp_who, sp_who2 etc...
Can anyone explain what, if any difference there is between the two. They seem to show the same thing, albeit with a slightly different set of columns. Also, BlitzFirst shows some other information in it's output as a separate output table
In this video, Brent shows his triage process in which he uses both sp_WhoIsActive and sp_BlitzFirst which makes me think there must be some difference but unless I missed something in the video I can't see why sp_WhoIsActive is required
sql-server troubleshooting sp-blitzfirst sp-whoisactive
sql-server troubleshooting sp-blitzfirst sp-whoisactive
asked 4 hours ago
SEarle1986
332213
asked 4 hours ago
SEarle1986
332213
asked 4 hours ago
SEarle1986
332213
asked 4 hours ago
SEarle1986
332213
asked 4 hours ago
SEarle1986
332213
332213
iirc, i think it's sp_BlitzWho that is more like sp_WhoIsActive
– Rich Benner
4 hours ago
It looks like BlitzWho is the first output table in BlitzFirst @ExpertMode = 1
– SEarle1986
2 hours ago
add a comment |Â
iirc, i think it's sp_BlitzWho that is more like sp_WhoIsActive
– Rich Benner
4 hours ago
It looks like BlitzWho is the first output table in BlitzFirst @ExpertMode = 1
– SEarle1986
2 hours ago
iirc, i think it's sp_BlitzWho that is more like sp_WhoIsActive
– Rich Benner
4 hours ago
iirc, i think it's sp_BlitzWho that is more like sp_WhoIsActive
– Rich Benner
4 hours ago
It looks like BlitzWho is the first output table in BlitzFirst @ExpertMode = 1
– SEarle1986
2 hours ago
It looks like BlitzWho is the first output table in BlitzFirst @ExpertMode = 1
– SEarle1986
2 hours ago
add a comment |Â
1 Answer
1
active
oldest
votes
up vote
4
down vote
accepted
They're just different scripts.
Adam's sp_WhoIsActive is powerful, free, and copyrighted. I've used it for at least a decade, and I love it, and I still continue to use it personally. However, it's not open source, which means you can't contribute code to it, and you're not allowed to distribute it to others.
We needed something we could redistribute to our clients for commercial purposes, and let them distribute it to THEIR clients (because some of our clients are software vendors and service providers). That's why we wrote sp_BlitzWho and licensed it with the MIT License, enabling us (and others) to do just about anything with it.
They're both great tools. I still teach people how to use sp_WhoIsActive because most folks don't need the ability to redistribute code or make improvements to it.
About why I still use sp_WhoIsActive - when I troubleshoot blocking chains, I prefer sp_WhoIsActive because of its get_locks parameter that shows locking in objects. We don't need the ability to edit that code or redistribute it, so we haven't bothered building that logic into sp_BlitzWho.
answered 48 mins ago
Brent Ozar
33.4k1999228
Thanks. PS - love your work!
– SEarle1986
47 mins ago
You're welcome!
– Brent Ozar
46 mins ago
add a comment |Â
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
4
down vote
accepted
They're just different scripts.
Adam's sp_WhoIsActive is powerful, free, and copyrighted. I've used it for at least a decade, and I love it, and I still continue to use it personally. However, it's not open source, which means you can't contribute code to it, and you're not allowed to distribute it to others.
We needed something we could redistribute to our clients for commercial purposes, and let them distribute it to THEIR clients (because some of our clients are software vendors and service providers). That's why we wrote sp_BlitzWho and licensed it with the MIT License, enabling us (and others) to do just about anything with it.
They're both great tools. I still teach people how to use sp_WhoIsActive because most folks don't need the ability to redistribute code or make improvements to it.
About why I still use sp_WhoIsActive - when I troubleshoot blocking chains, I prefer sp_WhoIsActive because of its get_locks parameter that shows locking in objects. We don't need the ability to edit that code or redistribute it, so we haven't bothered building that logic into sp_BlitzWho.
answered 48 mins ago
Brent Ozar
33.4k1999228
Thanks. PS - love your work!
– SEarle1986
47 mins ago
You're welcome!
– Brent Ozar
46 mins ago
add a comment |Â
up vote
4
down vote
accepted
They're just different scripts.
Adam's sp_WhoIsActive is powerful, free, and copyrighted. I've used it for at least a decade, and I love it, and I still continue to use it personally. However, it's not open source, which means you can't contribute code to it, and you're not allowed to distribute it to others.
We needed something we could redistribute to our clients for commercial purposes, and let them distribute it to THEIR clients (because some of our clients are software vendors and service providers). That's why we wrote sp_BlitzWho and licensed it with the MIT License, enabling us (and others) to do just about anything with it.
They're both great tools. I still teach people how to use sp_WhoIsActive because most folks don't need the ability to redistribute code or make improvements to it.
About why I still use sp_WhoIsActive - when I troubleshoot blocking chains, I prefer sp_WhoIsActive because of its get_locks parameter that shows locking in objects. We don't need the ability to edit that code or redistribute it, so we haven't bothered building that logic into sp_BlitzWho.
answered 48 mins ago
Brent Ozar
33.4k1999228
Thanks. PS - love your work!
– SEarle1986
47 mins ago
You're welcome!
– Brent Ozar
46 mins ago
add a comment |Â
up vote
4
down vote
accepted
up vote
4
down vote
accepted
They're just different scripts.
Adam's sp_WhoIsActive is powerful, free, and copyrighted. I've used it for at least a decade, and I love it, and I still continue to use it personally. However, it's not open source, which means you can't contribute code to it, and you're not allowed to distribute it to others.
We needed something we could redistribute to our clients for commercial purposes, and let them distribute it to THEIR clients (because some of our clients are software vendors and service providers). That's why we wrote sp_BlitzWho and licensed it with the MIT License, enabling us (and others) to do just about anything with it.
They're both great tools. I still teach people how to use sp_WhoIsActive because most folks don't need the ability to redistribute code or make improvements to it.
About why I still use sp_WhoIsActive - when I troubleshoot blocking chains, I prefer sp_WhoIsActive because of its get_locks parameter that shows locking in objects. We don't need the ability to edit that code or redistribute it, so we haven't bothered building that logic into sp_BlitzWho.
answered 48 mins ago
Brent Ozar
33.4k1999228
They're just different scripts.
Adam's sp_WhoIsActive is powerful, free, and copyrighted. I've used it for at least a decade, and I love it, and I still continue to use it personally. However, it's not open source, which means you can't contribute code to it, and you're not allowed to distribute it to others.
We needed something we could redistribute to our clients for commercial purposes, and let them distribute it to THEIR clients (because some of our clients are software vendors and service providers). That's why we wrote sp_BlitzWho and licensed it with the MIT License, enabling us (and others) to do just about anything with it.
They're both great tools. I still teach people how to use sp_WhoIsActive because most folks don't need the ability to redistribute code or make improvements to it.
About why I still use sp_WhoIsActive - when I troubleshoot blocking chains, I prefer sp_WhoIsActive because of its get_locks parameter that shows locking in objects. We don't need the ability to edit that code or redistribute it, so we haven't bothered building that logic into sp_BlitzWho.
answered 48 mins ago
Brent Ozar
33.4k1999228
edited 46 mins ago
answered 48 mins ago
Brent Ozar
33.4k1999228
answered 48 mins ago
Brent Ozar
33.4k1999228
answered 48 mins ago
Brent Ozar
33.4k1999228
33.4k1999228
Thanks. PS - love your work!
– SEarle1986
47 mins ago
You're welcome!
– Brent Ozar
46 mins ago
add a comment |Â
Thanks. PS - love your work!
– SEarle1986
47 mins ago
You're welcome!
– Brent Ozar
46 mins ago
Thanks. PS - love your work!
– SEarle1986
47 mins ago
Thanks. PS - love your work!
– SEarle1986
47 mins ago
You're welcome!
– Brent Ozar
46 mins ago
You're welcome!
– Brent Ozar
46 mins ago
add a comment |Â
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f222073%2fsp-whoisactive-vs-sp-blitzfirst-expertmode-1%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
iirc, i think it's sp_BlitzWho that is more like sp_WhoIsActive
– Rich Benner
4 hours ago
It looks like BlitzWho is the first output table in BlitzFirst @ExpertMode = 1
– SEarle1986
2 hours ago