Networks

Ask something
Discussion Locked

Monitor SQL usage by users

0 helpful
6 replies

by paulkayengheng

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

6 replies

by bfilmfan

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

by caestelle

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.

by jitesh.kannanchery

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

This discussion is closed to new replies.