Need Help: How to Get the currently running processes in sqlserver in .Net.
This is a discussion on Need Help: How to Get the currently running processes in sqlserver in .Net. within the ASP and ASP.NET Programming forums, part of the Web Development category; Hi Need help, I have a requirement, i have to get the currently running processes from sqlserver... and then i ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
08-14-2007, 03:43 AM
| |||
| |||
 Need Help: How to Get the currently running processes in sqlserver in .Net. Hi Need help, I have a requirement, i have to get the currently running processes from sqlserver... and then i have to get the each processess memory usuage and i have to find who is the user of the purticular query and i need to find the status of the query.... thanks for any help..... thnx....     |
| Sponsored Links |
|
08-16-2007, 01:01 AM
| |||
| |||
| How to Get the currently running processes in sqlserver in .Net: Solution Hi All, I got the solution for my problem.... we can get the currently running process from sqlsever using a simple select statement to the sysprocesses View. eg: select spid,loginame,hostname,cpu,memusage,cmd,status from sysprocesses order by memusage desc This query will return all the information i need. thnx.... |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| difference between oracle and sqlserver? | smani | Database Support | 1 | 08-23-2007 03:08 AM |
| MultiLanguageSupport-SQLSERVER | Murali | Database Support | 2 | 07-28-2007 03:28 AM |
| What are different transaction levels in SQLSERVER? | oxygen | Database Support | 1 | 07-26-2007 04:16 AM |
| How to Generate Various types of random numbers using SQLServer ? | Archer | Database Support | 1 | 07-16-2007 02:26 AM |
| Are you running a websites? | montyauto | The Lounge | 0 | 06-01-2007 03:12 PM |
All times are GMT -7. The time now is 02:55 PM.
