Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Process information

Status
Not open for further replies.
sebpas

sebpas

IS-IT--Management
Mar 30, 2001
39
CA
I'm looking for a way to see the processes activity and cpu/io percentage they're taking, kind of a task manager with the percentage and all. I'm using sql 7.0 and a dual processor board.
The purpose of this is to identify bottleneck processes within sql when I see my server's disk drives working continuously.
Is it in the MMC or is there some third party software that does it? I've already looked at the process info section of the MMC but can't find anything relevant...
 
Sort by date Sort by votes
You have to use the performance monitor that comes with Windows NT, and Windows 2000. The server that has SQL server installed on it automatically adds new counters specifically geared towards SQL Server.
 
Upvote 0 Downvote
Will it be able to tell me which SPID is taking all the juice?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EM1107
  • Locked
  • Question
Help finding a way to show my information on one row 3
Replies
11
Views
59
dhookom
dhookom
SaltyTheFrog
  • Locked
  • Question
Rework process not to use cursor 2
Replies
3
Views
70
gbaughma
gbaughma
bmacbmac
  • Locked
  • Question
How to hashbytes SQL information for one record spanning multiple rows 1
Replies
5
Views
136
Olaf Doschke
Olaf Doschke
Cpreston
  • Locked
  • Question
Adding an Alias column with standard information 1
Replies
3
Views
56
dhookom
dhookom
dwg23
  • Locked
  • Question
Query Returns Wrong Date Information
Replies
9
Views
75
dwg23
dwg23

Part and Inventory Search

Sponsor

Back
Top