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

tempdb¶ÔSQL ServerÊý¾Ý¿âÐÔÄÜÓкÎÓ°Ïì

tempdb¶ÔSQL ServerÊý¾Ý¿âÐÔÄÜÓкÎÓ°Ïì
 
±¾ÎĹؼü´Ê£ºSQL Server ÍøÂç
Ïà·´Èç¹û·ÃÎʺÜƵ·±,loading¾Í»á¼ÓÖØ,tempdbµÄÐÔÄܾͻá¶ÔÕû¸öDB²úÉúÖØÒªµÄÓ°Ïì.ÓÅ»¯tempdbµÄÐÔÄܱäµÄºÜÖØÒªµÄ,ÓÈÆä¶ÔÓÚ´óÐÍÊý¾Ý¿â.Èç¹ûʹÓÃÁÙʱ±í´¢´æ´óÁ¿µÄÊý¾ÝÇÒƵ·±·ÃÎÊ,¿¼ÂÇÌí¼ÓindexÒÔÔö¼Ó²éѯЧÂÊ.
¡¡  1.SQL ServerϵͳÊý¾Ý¿â½éÉÜ
¡¡¡¡SQL ServerÓÐËĸöÖØÒªµÄϵͳ¼¶Êý¾Ý¿â:master,model,msdb,tempdb.
¡¡¡¡master:¼Ç¼SQL ServerϵͳµÄËùÓÐϵͳ¼¶ÐÅÏ¢,°üÀ¨ÊµÀý·¶Î§µÄÔªÊý¾Ý,¶Ëµã,Á´½Ó·þÎñÆ÷ºÍϵͳÅäÖÃÉèÖÃ,»¹¼Ç¼ÆäËûÊý¾Ý¿âÊÇ·ñ´æÔÚÒÔ¼°ÕâЩÊý¾ÝÎÊÎļþµÄλÖõȵÈ.Èç¹ûmaster²»¿ÉÓÃ,Êý¾Ý¿â½«²»ÄÜÆô¶¯.
¡¡¡¡model:ÓÃÔÚSQL Server ʵÀýÉÏ´´½¨µÄËùÓÐÊý¾Ý¿âµÄÄ£°å¡£ÒòΪÿ´ÎÆô¶¯ SQL Server ʱ¶¼»á´´½¨ tempdb£¬ËùÒÔ model Êý¾Ý¿â±ØÐëʼÖÕ´æÔÚÓÚ SQL Server ϵͳÖС£
¡¡¡¡msdb:ÓÉSQL Server ´úÀíÓÃÀ´¼Æ»®¾¯±¨ºÍ×÷Òµ¡£
¡¡¡¡tempdb:ÊÇÁ¬½Óµ½ SQL Server ʵÀýµÄËùÓÐÓû§¶¼¿ÉÓõÄÈ«¾Ö×ÊÔ´£¬Ëü±£´æËùÓÐÁÙʱ±í,ÁÙʱ¹¤×÷±í,ÁÙʱ´æ´¢¹ý³Ì,ÁÙʱ´æ´¢´óµÄÀàÐÍ,Öмä½á¹û¼¯,±í±äÁ¿ºÍÓαêµÈ¡£ÁíÍ⣬Ëü»¹ÓÃÀ´Âú×ãËùÓÐÆäËûÁÙʱ´æ´¢ÒªÇó.
¡¡¡¡2.tempdbÄÚÔÚÔËÐÐÔ­Àí
¡¡¡¡ÓëÆäËûSQL ServerÊý¾Ý¿â²»Í¬µÄÊÇ,tempdbÔÚSQL ServerÍ£µô,ÖØÆôʱ»á×Ô¶¯µÄdrop,re-create. ¸ù¾ÝmodelÊý¾Ý¿â»áĬÈϽ¨Á¢Ò»¸öеÄ8MB(mdf file:8MB;ldf file:1MB, autogtouthÉèÖÃΪ10%)´óСrecovery modelΪsimpleµÄtempdbÊý¾Ý¿â.
¡¡¡¡tempdbÊý¾Ý¿â½¨Á¢Ö®ºó,DBA¿ÉÒÔÔÚÆäËûµÄÊý¾Ý¿âÖн¨Á¢Êý¾Ý¶ÔÏó,ÁÙʱ±í,ÁÙʱ´æ´¢¹ý³Ì,±í±äÁ¿µÈ»á¼Óµ½tempdbÖÐ.ÔÚtempdb»î¶¯ºÜƵ·±Ê±,Äܹ»×Ô¶¯µÄÔö³¤,ÒòΪÊÇsimpleµÄrecovery model,»á×îС»¯ÈÕÖ¾¼Ç¼,ÈÕÖ¾Ò²»á²»¶ÏµÄ½Ø¶Ï.
¡¡¡¡3.ÈçºÎºÏÀíµÄÓÅ»¯tempdbÒÔÌá¸ßSQL ServerµÄÐÔÄÜ
¡¡¡¡Èç¹ûSQL Server¶Ôtempdb·ÃÎʲ»Æµ·±,tempdb¶ÔÊý¾Ý¿â²»»á²úÉúÓ°Ïì;Ïà·´Èç¹û·ÃÎʺÜƵ·±,loading¾Í»á¼ÓÖØ,tempdbµÄÐÔÄܾͻá¶ÔÕû¸öDB²úÉúÖØÒªµÄÓ°Ïì.ÓÅ»¯tempdbµÄÐÔÄܱäµÄºÜÖØÒªµÄ,ÓÈÆä¶ÔÓÚ´óÐÍÊý¾Ý¿â.
¡¡¡¡×¢:ÔÚÓÅ»¯tempdb֮ǰ,ÇëÏÈ¿¼ÂÇtempdb¶ÔSQL ServerÐÔÄܲúÉú¶à´óµÄÓ°Ïì,ÆÀ¹ÀÓöµ½µÄÎÊÌâÒÔ¼°¿ÉÐÐÐÔ.
¡¡¡¡3.1×îС»¯µÄʹÓÃtempdb
¡¡¡¡SQL ServerÖкܶàµÄ»î¶¯¶¼»î·¢ÉúÔÚtempdbÖÐ,ËùÒÔÔÚijÖÖÇé¿ö¿ÉÒÔ¼õÉÙ¶à¶ÔtempdbµÄ¹ý¶ÈʹÓÃ,ÒÔÌá¸ßSQL ServerµÄÕûÌåÐÔÄÜ.
¡¡¡¡ÈçÏÂÓм¸´¦Óõ½tempdbµÄµØ·½:
¡¡¡¡(1)Óû§½¨Á¢µÄÁÙʱ±í.Èç¹ûÄܹ»±ÜÃâ²»ÓÃ,¾Í¾¡Á¿±ÜÃâ. Èç¹ûʹÓÃÁÙʱ±í´¢´æ´óÁ¿µÄÊý¾ÝÇÒƵ·±·ÃÎÊ,¿¼ÂÇÌ


Ïà¹ØÎĵµ£º

¾­µäSQLÓï¾ä´óÈ«

Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ë ......

½«sql²éѯ³öÀ´µÄÊý¾Ýת»¯Îª¶ÔÏó

import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import xml.dao.admin.AdminArea;
public class NativeSQLQuery extends HibernateDaoSupport {
......

SQL Server 2005 ExpressÊý¾Ý¿âΪ¡°Ö»¶Á¡±

×ÊÁÏÒýÓÃ:http://www.knowsky.com/339654.html
ÎҵIJÙ×÷ϵͳΪWindows 2003 Server , ÎļþϵͳNTFS, ÔÚSQL Server 2005 Express Éϸ½¼Ó(Attach)´ÓÁíÍâһ̨µçÄÔCopy¹ýÀ´µÄÊý¾Ý¿âºó£¬Êý¾Ý¿âΪ“Ö»¶Á”¡£ÈçÏÂͼ£º
½â¾ö°ì·¨£º
´ò¿ª SQL Server Configuration Manager, ´ò¿ªSQL Server SQLEXPRESS µÄÊôÐÔ£¬ÈçÏÂͼ£º ......

´óÁ¬Ä³ÍøÂçÓÎÏ··þÎñÆ÷ £¨SQL SERVER 2008£© ÐÞ¸´³É¹¦




¿Í»§Ãû³Æ
´óÁ¬Ä³ÍøÂçÓÎÏ··þÎñÆ÷ £¨SQL SERVER 2008£© ÐÞ¸´³É¹¦


Êý¾Ý¿â°æ±¾
SQL SERVER 2008


Îļþ´óС
5G


¹ÊÕÏÃèÊö
¿Í»§µÄÓÎÏ··þ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ