Monitoring SQL Server

wasi_shez · #1 (**permalink**) 12-19-11, 04:06

Hi
I want to monitor my SQL Server.

Scenario:
There is only one Username and Hundreds of Users connecting from different machines on same server.

I want to Monitor :

Machine Name of the User from He connected the SQL Server.

Any way?

Thanks in advance.

Pat Phelan · #2 (**permalink**) 12-19-11, 12:49

A lot depends on what version of SQL Server you're using and what tools the client machines are using to connect to your SQL Server. You can probably get by with just:

Code:

SELECT hostname
   FROM master.dbo.sysprocesses
   WHERE  50 <= spid

-PatP

wasi_shez · #3 (**permalink**) 12-20-11, 03:14

SELECT hostname
FROM master.dbo.sysprocesses
WHERE 50 <= spid

Does this possible to fetach this all info through Date and time?

aflorin27 · #4 (**permalink**) 12-20-11, 04:00

SQL Server Profiler

Pat Phelan · #5 (**permalink**) 12-21-11, 09:41

Quote:

Originally Posted by wasi_shez

Does this possible to fetach this all info through Date and time?

Please re-phrase this question. I don't understand.

-PatP

wasi_shez · #6 (**permalink**) 12-21-11, 09:53

I mean if i want to put the filter on the same query of Date or time

then?

Pat Phelan · #7 (**permalink**) 12-21-11, 17:07

The master.dbo.sysprocesses table shows the conditions of the connections to this server at this particular instant. It shows when that connection logged in (was created), and when the last batch was submitted from the client to the server.

You can not query master.dbo.sysprocesses to see what happened six hours, days, months, etc ago. It only shows sessions that are connected to the server right now.

-PatP

Internet Services

Web Development

Digital Marketing

Consumer Tech