General discussion

Locked

Monitor SQL usage by users

By kaypaul ·
How can I see the resources usage at any one time in the operating system(W2K) and SQL 2000 server?

How can I indentify a process ID in SQL 2000?

How can I monitor the SQLAgent jobs and packages running parallel and serially?

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by BFilmFan In reply to Monitor SQL usage by user ...

You can either use a monitoring product such as MOM, NetIQ, etc. or you can become an expert at reading Microsoft's performance monitoring counters.

I'd recommend that you use a monitoring product.

Sql 2000's Operations Guide is located here:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx

There are several excellent O'Reilly books on base system OS and SQL monitoring.

One of the better blogs on Sql is located here:
http://vyaskn.tripod.com/microsoft_sql_server_articles.htm

Collapse -

by kaypaul In reply to

The answer is very general. Can I have more specific steps or commands, please.

Collapse -

by caestelle In reply to Monitor SQL usage by user ...

Run SQL profiler by going to Start, Programs, Microsoft SQL Server and Profiler. Once the program opens click file, new and trace. At that point the first screen that pops up will ask you what SQL Server you want to run the trace and for the sa username and password. After you enter that the trace properties window will open allowing you to give your trace a name and it will also allow you to save it to a file if you would like.
This utility should take care of all of your questions.

Collapse -

by kaypaul In reply to

Poster rated this answer.

Collapse -

by jitesh.kannanchery In reply to Monitor SQL usage by user ...

Hi,
You can use sp_who or Sp_who2 procedure to indentify a process ID in SQL SERVER also you can use SQL Profile tool to monitor user activity, Packages which running and jobs which is running.

Regards,
Jitesh

Collapse -

by kaypaul In reply to Monitor SQL usage by user ...

This question was closed by the author

Back to Networks Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums