Performance Optimization of SQL Server Database

xiaoxiao2021-03-06  72

Set the maximum query time

Set reasonable memory maximum in SQL 2000

1. Several a few tables that are often queried in your table, that is, transversely divided 2, divide different types into several tables, vertical sections 3, and commonly used construction index 4, servers put a few Hard disk, put data, log, index panel, can improve IO throughput 5, optimizer, optimize your query 6, consider redundancy, this can reduce connection 7, can consider establishing a statistics, is real-time generation total Table, this can avoid counting each time 8, test with extreme data

转载请注明原文地址:https://www.9cbs.com/read-121298.html

New Post(0)