combining SP_who and SP_LOCK result sets

Question

Post reply

combining SP_who and SP_LOCK result sets

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

Paul White SSC Guru Points: 150467 More actions · Answer 1

Gianluca Sartori (1/10/2012)
Activity what? 😀

Well exactly. The primary motivation for Adam writing WIA was the awfulness that is Activity Monitor.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

spaghettidba SSC Guru Points: 105732 More actions · Answer 2

SQL Kiwi (1/10/2012)
Gianluca Sartori (1/10/2012)
Activity what? 😀
Well exactly. The primary motivation for Adam writing WIA was the awfulness that is Activity Monitor.

Don't mistreat it that way: it was almost usable in SQL 2005. Something went wrong thereafter.

-- Gianluca Sartori

Paul White SSC Guru Points: 150467 More actions · Answer 3

Gianluca Sartori (1/10/2012)
Don't mistreat it that way: it was almost usable in SQL 2005. Something went wrong thereafter.

Almost usable, perhaps, at a stretch. 2008 was a big step back from there, certainly.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

SQL Kiwi (1/10/2012)
Gianluca Sartori (1/10/2012)
Don't mistreat it that way: it was almost usable in SQL 2005. Something went wrong thereafter.
Almost usable, perhaps, at a stretch. 2008 was a big step back from there, certainly.

I am curious what you guys think makes 2008 AM worse than 2005 AM

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

kwoznica SSCertifiable Points: 5275 More actions · Answer 5

SQLRNNR (1/10/2012)
SQL Kiwi (1/10/2012)
Gianluca Sartori (1/10/2012)
Don't mistreat it that way: it was almost usable in SQL 2005. Something went wrong thereafter.
Almost usable, perhaps, at a stretch. 2008 was a big step back from there, certainly.
I am curious what you guys think makes 2008 AM worse than 2005 AM

I find it slower than am in 2005 and scrolling down the drop down list to select a user for instance can be troublesome with the refresh time. I could change the refresh interval but haven't.

Paul White SSC Guru Points: 150467 More actions · Answer 6

SQLRNNR (1/10/2012)
I am curious what you guys think makes 2008 AM worse than 2005 AM

The design, implementation, and performance mostly 😀

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

SQL Kiwi (1/10/2012)
SQLRNNR (1/10/2012)
I am curious what you guys think makes 2008 AM worse than 2005 AM
The design, implementation, and performance mostly 😀

K - I see you on all three. I thought both 2005 and 2008 were bad but thought that 2008 had gotten a bit better - though not adequate still performance wise.

Design could have been far better.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

spaghettidba SSC Guru Points: 105732 More actions · Answer 8

SQL Kiwi (1/10/2012)
SQLRNNR (1/10/2012)
I am curious what you guys think makes 2008 AM worse than 2005 AM
The design, implementation, and performance mostly 😀

+1

Performance is my major concern.

Also, usability (is this a real word?). Has lots of things you don't need and misses the basics.

-- Gianluca Sartori