Hi Alex,

Thank you for looking into this script.

Can you please substantiate your claim and explain why it doesn't make sense?

We are always willing to improve the quality of our scrips.

It...

Hi,

Thank you very much for your comments and your suggestion.

The stored procedure returns the HostName.

Although it would be a simple exercise to get the IP address for the given...

Hi,

Thank you very much for your comments and your suggestion.

The stored procedure did have an interval parameter in the design phase, however, I found in the past two years since...

Hi,

Thank you for using the script and posting the comments. Could you please use the same login parameter in sp_who2 and compare the output ?

You should get the same results...

Hi,

This is possible, if there is no activity on the server, during the 3 seconds period when the sp_whocpu calculates the cpu_delta.

The spid that runs sp_whocpu is ignored.

None of the...

Hi,

The TAB characters in the original script appear as a series of four question marks in the online version. I have asked SQL Server Central for advice and this will...

Hi,

It appears that the TAB character was replaced by a series of 4 question marks (????) in the script I submitted.

I will contact SQL Server Central and this will be...