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 «««123

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: Friday, August 29, 2014 12:59 PM
Points: 342, Visits: 691
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: Friday, August 29, 2014 12:59 PM
Points: 342, Visits: 691
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, August 28, 2014 9:47 AM
Points: 371, Visits: 964
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: Friday, August 29, 2014 12:59 PM
Points: 342, Visits: 691
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, August 28, 2014 9:47 AM
Points: 371, Visits: 964
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: Friday, August 29, 2014 12:59 PM
Points: 342, Visits: 691
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: Friday, August 29, 2014 12:59 PM
Points: 342, Visits: 691
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: Friday, August 29, 2014 12:59 PM
Points: 342, Visits: 691
The new version's online. :)
Post #1522659
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse