易截截图软件、单文件、免安装、纯绿色、仅160KB

SQL SERVER 查看CPU利用率

 --查看CPU利用率
-- CREATE PROCEDURE sp_GetTop10_CPU () AS
BEGIN
  SET NOCOUNT ON
  DECLARE @cinterval char(8)
  DECLARE @interval int
  SET @cinterval = '00:00:10'
  CREATE TABLE #thread
  (
    RUN INT NOT NULL,
    SPID INT NOT NULL,
    THREAD INT NULL,
    STATUS varchar(30) NOT NULL,
    [IO] INT NOT NULL,
    CPU INT NOT NULL,
    MEM INT NOT NULL,
    LOCKS int NOT NULL,
    BLK INT NOT NULL,
    hostname varchar(30) NOT NULL,
    hostprocess INT NOT NULL
    CONSTRAINT PK_thread1 PRIMARY KEY CLUSTERED (RUN,SPID)
  )
  INSERT #thread
  SELECT 1,pr.spid,pr.kpid,pr.status,pr.physical_io,pr.cpu, pr.memusage,ISNULL(count(lk.spid),0),pr.blocked , max(pr.hostname), max(pr.hostprocess)
  from   master.dbo.sysprocesses pr
  LEFT OUTER JOIN  master.dbo.syslocks  lk
  ON pr.spid = lk.spid
  WHERE pr.spid>=50 AND pr.spid<>@@SPID
  GROUP BY pr.spid,pr.kpid,pr.status,pr.physical_io, pr.cpu,pr.memusage,pr.blocked
  WAITFOR DELAY @cinterval
  INSERT #thread
  SELECT 2,pr.spid,pr.kpid,pr.status,pr.physical_io,pr.cpu, pr.memusage,ISNULL(count(lk.spid),0),pr.blocked , max(pr.hostname), max(pr.hostprocess)
  from   master.dbo.sysprocesses pr
  LEFT OUTER JOIN  master.dbo.syslocks  lk
  ON pr.spid = lk.spid
  WHERE pr.spid>=50 AND pr.spid<>@@SPID
  GROUP BY pr.spid,pr.kpid,pr.status,pr.physical_io, pr.cpu,pr.memusage,pr.blocked
  SELECT TOP 10 T.*
  from
  (
    SELECT a.SPID, a.hostname, b.hostprocess, b.STATUS, (b.CPU-a.CPU) as 'CPU'
    from #thread a
    JOIN #thread b
    ON a.SPID=b.SP


相关文档:

ASP.NET远程备份恢复SQL Server数据库

///<summary>
      ///备份数据库到本地磁盘
      ///</summary>
    public bool BackUp(string BackUpFile)
    {
        try
&nbs ......

sql基础知识

SQL语言由命令、子句、运算和集合函数等构成。在SQL中,数据定义语言DDL(用来建立及定义数据表、字段以及索引等数据库结构)包含的命令有CREATE、DROP、ALTER;数据操纵语言DML(用来提供数据的查询、排序以及筛选数据等功能)包含的命令有SELECT、INSERT、UPDATE、DELETE。
一、SQL语句
(1)Select 查询语句
语法:SE ......

SQL SERVER 查看CPU利用率

 --查看CPU利用率
-- CREATE PROCEDURE sp_GetTop10_CPU () AS
BEGIN
  SET NOCOUNT ON
  DECLARE @cinterval char(8)
  DECLARE @interval int
  SET @cinterval = '00:00:10'
  CREATE TABLE #thread
  (
    RUN INT NOT NULL,
    SPI ......

用mysql源码进行SQL解析

http://blog.csdn.net/iamstillzhang/archive/2007/04/01/1548377.aspx
用mysql源码进行SQL解析
Mysql是通过yacc进行SQL语句解析的,这里介绍一下如何使用mysql的源码进行SQL语句解析。由于Mysql的源代码注释比较少,而且缺少资料,所有些地方研究不够深入。
1        Filed介绍
MY ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号