ÈçºÎ¼ì²éSQL Server ÄÚ´æÆ¿¾±
DBCC memorystatus
--²éѯ»º³åÇø³ØÏûºÄµÄÄÚ´æ×ÜÁ¿°üÀ¨AWE
SELECT
SUM(multi_pages_kb+virtual_memory_committed_kb+shared_memory_committed_kb+
awe_allocated_kb) AS [Used by BPool, kb]
from sys.dm_os_memory_clerks WHERE type='MEMORYCLERK_SQLBUFFERPOOL'
--È·ÈÏÄÇЩÄÚ²¿×齨ÇÔÈ¡ÁË»º³åÇø³ØÖеĴ󲿷ֵÄÒ³Ãæ
SELECT TOP 10 type, SUM(single_pages_kb) AS stolen_mem_kb
from sys.dm_os_memory_clerks
GROUP BY type ORDER BY SUM(single_pages_kb) DESC
--È·ÈÏÔÚ»º³åÇø³ØÍâ·ÖÅäÁËÄÚ´æµÄÄÚ²¿×齨
SELECT type, SUM(multi_pages_kb) AS memory_allocated_kb
from sys.dm_os_memory_clerks
WHERE multi_pages_kb!=0
GROUP BY type
Ïà¹ØÎĵµ£º
1¡¢°´Ê±¼äÅÅÐò
select * from tbl_lms_loginhistory order by loginhistory_logintime desc
2¡¢
ÔÚÒ»¸öÊý¾Ý¿âÖÐÊÇÏÂÁеÄÑù×Ó
³µ´Î Éí·ÝÖ¤ºÅ
27 1
27 2
45 1
25 1
45 2
ÏÖÔÚÎÒÏë »ñµÃµÄÊÇ
³µ´Î ³Ë×ø´ÎÊý
25 1
27 3
45 2
ÇëÎÊ£¬ÎÒµÄSQLÓï¾ä¸ÃÔõôд£¿
select ³µ´ ......
select f.tablespace_name,a.total,u.used,f.free,round((u.used/a.total)*100) "% used", round((f.free/a.total)*100) "% Free"
from
(select tablespace_name, sum(bytes/(1024*1024)) total
from dba_data_files group by tablespace_name) a,
(select tabl ......
SQL_Plus²Ù×÷ÃüÁî ¸½Â¼B SQL*PLUS
SQL*PLUS ÊÇOracleÌṩµÄÒ»¸ö¹¤¾ß³ÌÐò£¬Ëü²»½ö¿ÉÒÔÓÃÓÚ²âÊÔ£¬ÔËÐÐSQLÓï¾äºÍPL/SQL¿é£¬¶øÇÒ»¹¿ÉÒÔÓÃÓÚ¹ÜÀíOracleÊý¾Ý¿â
1.Æô¶¯sql*plus
ΪÁËʹÓÃsql*plus£¬±ØÐëÊ×ÏÈÒªÆô¶¯sql*plus¡£Oracle²»½öÌṩÁËÃüÁîÐкÍͼÐνçÃæµÄsql*plus£¬¶øÇÒ»¹¿ÉÒÔÔÚwebä¯ÀÀÆ÷ÖÐÔËÐÐ.
  ......
Ä¿µÄ£ºÍ¨¹ýHTTP·ÃÎÊMS SSAS 2005
ÅäÖ÷½·¨£º
Èç¹ûÏë·ÃÎʶÔÓ¦µÄcube£¬ÔòÐèÖ¸¶¨cubeËùÔڵķþÎñÆ÷Ãû³Æ
ʹ֮¿ÉÒÔͨ¹ýHTTPÐÒé½øÐзÃÎÊ£¬¿ÉÒÔ·µ»ØMDX²éѯËùµÃµ½µÄ½á¹û¼¯ºÍÔªÊý¾Ý
²éѯ½á¹û¼¯µÄ·½·¨ÊÇ£ºExecute()£¬ËüÄܹ»·µ»ØMDXÓï¾äµÄ²éѯ½á¹û
²éѯ½á¹û¼¯ÔªÊý¾Ý·½·¨£ºDiscover()£¬ËüÄܹ»·µ»ØMDXÓï¾äµÄÔªÊý¾ÝÐÅÏ¢¡£¸Ã·½·¨½ÏEx ......
½ñÌì°²×°sql server2000.ϵͳÊÇXP professional¡£Ê×ÏÈÏȰ²×°sqlserverÆóÒµ°æµÄ£¬Ö»Äܰ²×°¿Í»§¶Ë£»È»ºó°²×°sqlserver¿ª·¢°æ£¬¾Í ±»¹ÒÆð£¬Òò´ËÍøÉÏËÑÂÞÏà¹ØÐÅÏ¢¡£
1¡¢ Èô³öÏÖ¹ÒÆðºó£¬¿É°´ÏÂÁвÙ×÷½øÐУ¬±¾ÈËÒѾÊÔÓùý£º
ÔÚÔËÐд°¿ÚÊäÈëregedit£¬´ò¿ª×¢²á±í±à¼Æ÷£¬ÔÚHKEY_LOCA ......