can help to get the below result

Question

can help to get the below result

ravishankar.yedoti

Right there with Babe

Points: 738
More actions
September 9, 2011 at 6:21 am

#244618

i need result as below ..... can u please help me
i tried with sp_who2
SPID 246
State sleeping
Login xxxx
Hostname xx
Blocking None
Database xxx
Last batch 09/09 04:32:38
Query xxxxxx

Viewing 7 posts - 1 through 6 (of 6 total)

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

Adam Machanic's sp_WhoIsActive does this and MUCH more:

http://sqlblog.com/blogs/adam_machanic/archive/2011/04/27/who-is-active-v11-00-a-month-of-activity-monitoring-part-27-of-30.aspx

-- Gianluca Sartori

ravishankar.yedoti Right there with Babe Points: 738 More actions · Answer 2

i can't access the link below

sp_whoisactive is throwing an error that no storedprocedure

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

ravishankar.yedoti (9/9/2011)
i can't access the link below
sp_whoisactive is throwing an error that no storedprocedure

Open the link I posted (if it doesn't work, check your settings).

Download the code and create sp_WhoIsActive.

-- Gianluca Sartori

Cadavre SSC-Forever Points: 41690 More actions · Answer 4

ravishankar.yedoti (9/9/2011)
i can't access the link below
sp_whoisactive is throwing an error that no storedprocedure

There's no problem with the link provided by Gianluca, but if you can't access it then the code is attached to this post.

--Edit--

Btw, thanks Gianluca. This seems very useful and I hadn't heard of it before - I had been using something of my own creation that does a lot less.

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

spaghettidba SSC Guru Points: 105732 More actions · Answer 5

Cadavre (9/9/2011)
ravishankar.yedoti (9/9/2011)
i can't access the link below
sp_whoisactive is throwing an error that no storedprocedure
There's no problem with the link provided by Gianluca, but if you can't access it then the code is attached to this post.
--Edit--
Btw, thanks Gianluca. This seems very useful and I hadn't heard of it before - I had been using something of my own creation that does a lot less.

Adam Machanic is simply great!

-- Gianluca Sartori

ravishankar.yedoti Right there with Babe Points: 738 More actions · Answer 6

ravishankar.yedoti

Right there with Babe

Points: 738

September 11, 2011 at 9:26 pm

#1379775

thanks, it help's me a lot.