SQL Server Performance

SELECT * FROM sys.sysprocesses WHERE waittime >120000

Discussion in 'Performance Tuning for DBAs' started by jagpalsingh4, May 1, 2008.

  1. jagpalsingh4 New Member

    Hi, will u plz tell when i try to run this query in sql 2000 its not working .Because in sql 2000 there is no dmv of sys.processes so will u plz tell me where can i look for this.Any suggestion ???
    SELECT * FROM sys.sysprocesses WHERE waittime >120000
    jagpal singh
  2. satya Moderator

    Too fast in SQL 2000 [:)], remove [sys.] and replace with [master..], you can use DMV sys.dm_exec_sessions in sql 2005.
  3. rohit2900 Member

    When I ran the belwo query I got 4 records but what next should I do in order to get to the root cause of the problem
    SELECT * FROM master.dbo.sysprocesses WHERE waittime >120000
    my server's configuration is
    Intel Xeon 2.8 GHZ, 2GB RAM, SQL 2K STD edition, 73 GB 15000 RPM SCSI HDD, Two database in simple recovery DB sizes around 12GB & 8 GB.
    Any Suggestions,

  4. rohit2900 Member

    When I cross checke the same SP id through sp_who2 I got below result
    6 BACKGROUND sa . . master TASK MANAGER 0 0 04/29 04:22:39 6
    and the select statement give below record
    6 0 0 0x0000 781813890 RESOURCE_QUEUE 1 1 0 0 3 2008-04-29 04:22:39.797 2008-04-29 04:22:39.797 0 0 background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0
    Command is ran through Task Manager....I'm confused.


Share This Page