sql最全的常用命令语句

sql最全的常用命令语句询某个数据库的连接数selectcount(*)fromMaster.dbo.SysProcesseswheredbid=db_id()--前10名其他等待类型SELECTTOP10*fromsys.dm_os_wait_statsORDERBYwait_time_msDESCSELECT*FROMsys.dm_os_wait_statsWHEREwait_typelike'PAGELATCH%'ORwait_typelike'LAZYWRITER_SLEEP%'--CPU的压力SELECTschedule