 |
|
 |
| |
Developer on focus
Anton Zamov is a dipl. engineer with more than 6 years of active professional
experience and many awards ...
read more>>
|
|
 |
 |
 |
|
|
|
|
| |
|
How to get the active processes running in Microsoft SQL Server database?
|
The method listed below returns a dataset containing information
for the active processes running in Microsoft SQL Server.<br>
public DataSet GetActiveProcesses(string serverName,string user, string password)
{
/*
This method is created by Anton Zamov.
web site: http://zamov.online.fr
Feel free to use and redistribute this method
in condition that you keep this message intact.
*/
DataSet ds = new DataSet();
try
{
SqlConnection cn = new SqlConnection("Server="+serverName+"; Database=master; UId="+user+"; Pwd="+password+"");
SqlDataAdapter cmd = new SqlDataAdapter("select spid,loginame,hostname,cpu,memusage,cmd,status from sysprocesses where status='runnable' order by memusage desc",cn);
cmd.Fill(ds,"nc");
}
catch(Exception exc)
{
System.Windows.Forms.MessageBox.Show("SQL Server is not running or access is denied!");
}
return ds;
}
|
About the author of this programming example or tutorial:
Anton Zamov is a software engineer with more than6 years
of active experience in web and software development and design.
Anton Zamov has extensive experience and broad knowledgebase
in C# and JAVA programming and has created a lot of
running e-commerce systems, portals and content management
systems using PHP and other web development technologies.
For more information about Anton Zamov, you may visit the personal web site of
Anton Zamov.
|
|
|
|
|
|
|
|
