C# free example : How to get the active processes running in Microsoft SQL Server database? tutorial sample code

home page latest news web development curriculum vitae scripts contact me

• C# (Microsoft .NET)
• JAVA
• Dynamic HTML
• PHP & MySQL
• ASP.NET - C# & VB.NET
• Perl & CGI
• C | C++
• Vector Markup Language
• SMIL
• Assembler
• Databases
• Wap Development
• Web site promotion
• Web Marketing

How to get the active processes running in Microsoft SQL Server database?

(C# free example written by Anton Zamov.)

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;
}

Jobs Portal, poweful jobs board software

PHP Mall, multi vendors mall website software

Car Portal, php script for auto classifieds websites

NetArt Media, software products and services

Real Estate Portal, web software for real estate portals

Blog System, multi user blog hosting script

PHP Store, powerful e-commerce system written in PHP