Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81

    Unanswered: sysprocesses.waittype

    Hi,

    The column waittype of master..sysprocesses table contains binary numbers.
    I am looking for their codes. I know that Microsoft has published these codes for SQL Server 7 (here: http://support.microsoft.com/default...b;EN-US;244455 ), but I need the codes of SQL Server 2000.

    And yes, I've checked spt_values - they are not there.


    Any help will be appreciated,
    Thanks,
    kukuk.
    --
    kukuk

  2. #2
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81
    OK, I've found this:

    http://support.microsoft.com/default...b;en-us;822101

    The problem is that if you run DBCC SQLPERF(waitstats), you get much more counters than are described in this article. So maybe someone knows the values for others ?

    Also, I wonder how these codes are stored ? Are they just hardcoded ? Or are they taken from a table ?
    --
    kukuk

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I believe, but have no proof, that the waittype values are hardcoded into the .dlls and .exes of SQL Server. I think they are treated similar to semaphores. Again, I have no documentation to back that up, but I have not seen any of the waittype values in any table.

  4. #4
    Join Date
    Feb 2003
    Location
    Amsterdam
    Posts
    8

    Lightbulb Waittypes sql server 2000 explained

    You will find them here:

    http://sqldev.net/misc/WaitTypes.htm

    Regards, Desmond

  5. #5
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81
    Quote Originally Posted by desmond_sql
    You will find them here:

    http://sqldev.net/misc/WaitTypes.htm

    Regards, Desmond
    I know this list - it does not contain all of them
    --
    kukuk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •