解决SQL慢的问题(邹建)（Solving the problem of slow SQL (Zou Jian)）.docVIP

解决SQL慢的问题(邹建)（Solving the problem of slow SQL (Zou Jian)） - first, check and repair the database with the following statement / / and index fragmentation (it takes a long time to do this work when the system is free) USE MASTER GO Sp_dboption your database name, single user, true Go DBCC CHECKDB (your database name, REPAIR_REBUILD) Go USE your database name Go Exec, sp_msforeachtable,DBCC, CHECKTABLE (` , REPAIR_REBUILD ) Exec, sp_msforeachtable,DBCC, DBREINDEX (, ) Go Sp_dboption your database name, single user, false Go Lets see if the configuration can be optimized 3. optimize tempdb performance General recommendations for the physical location and database options settings for the tempdb database include: Make the tempdb database automatically expanded as needed. This ensures that the query is not terminated until execution is complete, and that the query generates an intermediate result set stored in the tempdb database that is much larger than expected. Set the initial size of the tempdb database file to a reasonable size to avoid automatically expanding files when more space is needed. If the tempdb database is extended too often, performance can be adversely affected. Set the percentage of the file growth increment to a reasonable size to avoid the tempdb database file growing by too small value. If the file growth is too small compared to the amount of data written to the tempdb database, the tempdb database may need to be extended throughout, thus impairing performance. Place the tempdb database on a fast I/O subsystem to ensure good performance. Striping tempdb databases on multiple disks for better performance. Put the tempdb database on a disk other than the disk used by the user database. For more information, see expanding databases. 4. optimize server: Optimizing server performance with memory configuration options Microsoft? SQL Server? 2000 memory management components eliminate the need for manual management of the memory available to SQL Serve