Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234»»

usp_who5 Expand / Collapse
Author
Message
Posted Thursday, April 5, 2012 1:33 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 11, 2014 10:03 AM
Points: 371, Visits: 737
No problem. I seem to remember something about certain "date / time" columns in some of the system tables having ridiculous values (sometimes) for some reason which could be the issue (unfortunately I don't remember 100% what the details were behind that, could have been something I briefly scanned in an article on the net...). Let me know if it continues and you manage to track down the raw data value. With this I can write handling for it. :)
Post #1279117
Posted Monday, August 19, 2013 12:38 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 11, 2014 10:03 AM
Points: 371, Visits: 737
FYI: A few minor changes coming...

Minor Code Formatting Changes / Bug Fixes And Changes To Date Calculation Methods
Post #1485949
Posted Thursday, September 19, 2013 7:49 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:55 PM
Points: 372, Visits: 989
Very nice

Cheers
Post #1496402
Posted Thursday, September 19, 2013 7:59 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 11, 2014 10:03 AM
Points: 371, Visits: 737
Thank you! :)
Post #1496407
Posted Thursday, September 19, 2013 8:18 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:55 PM
Points: 372, Visits: 989
The more I look at it the more I like it. This thing really does have everything you need in one place. I tested it on 2005, 2008 and 2012 and found no issues. Great work and thanks for taking the time to put this together.

Cheers
Post #1496421
Posted Thursday, September 19, 2013 8:38 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 11, 2014 10:03 AM
Points: 371, Visits: 737
Thank you, again! I really tried to make it a "one-stop" stored proc. :)
Post #1496436
Posted Wednesday, December 11, 2013 10:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 11, 2014 10:03 AM
Points: 371, Visits: 737
For anyone interested, I just submitted a new version of the proc (still awaiting approval from SQL Server Central though...).

Additional output columns added:

Batch_Pct: Percentage of the batch which has been processed
Command_Pct: Percentage of work completed (applicable to a limited set of commands)
Command_Time_Left: Time left before the command completes (DAYS HH:MM:SS)
Command_Completion: Estimated completion time for the command
Deadlock_Priority: Deadlock priority of the session
Isolation_Level: Isolation level of the session
Last_Row_Count: Row count produced by the last statement executed in the batch
Lock_Details: Lock details of the session (in XML format)
Lock_Timeout_Seconds: Lock timeout of the session
Previous_Error: Previous error returned by the session

Hope everyone likes the updates.
Post #1521972
Posted Friday, December 13, 2013 6:29 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 11, 2014 10:03 AM
Points: 371, Visits: 737
The new version's online. :)
Post #1522659
Posted Monday, November 3, 2014 2:12 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 12:18 PM
Points: 11, Visits: 13
You have created a great script! The info is exactly what is needed to pinpoint blockages. The format of your select statement also makes it extremely easy to re-arrange the output columns to put the values most important to me up front.

I discovered that copy/paste from the web page converts periods to special characters in some places, but those were quickly cleaned up. You probably have no control over how the web page processes them during copy/paste anyway. Again, thanks for the great script!
Post #1630619
Posted Monday, November 3, 2014 2:42 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 11, 2014 10:03 AM
Points: 371, Visits: 737
rfulbrig (11/3/2014)
You have created a great script! The info is exactly what is needed to pinpoint blockages. The format of your select statement also makes it extremely easy to re-arrange the output columns to put the values most important to me up front.

I discovered that copy/paste from the web page converts periods to special characters in some places, but those were quickly cleaned up. You probably have no control over how the web page processes them during copy/paste anyway. Again, thanks for the great script!


Thank you very much, I am so glad it helped you. Just curious, what web browser are you using to copy / paste the script?
Post #1630624
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse