Can increase the memory of minutes per visit, to improve the performance of queries, the hash or sort operations, if the SQL Server has a large amount of memory available and there are many queries running concurrently on the server. SQL Server automatically assigns a minimal amount of memory in this configuration is. Memory min per query The default value is equal to 1024 Kb
You can increase the max async IO option if the SQL Server is running on a server disk subsystem performance, high-speed intelligent high (such as hardware-based RAID with 10 disks).
This option specifies the maximum number of requests to disk I / O asynchronous to the entire server can issue against a file. In fact, async max IO supports SQL Server option not in SQL Server 2000.
You can change the option network packet size ‘to the appropriate value. This option can improve performance on networks whose base topology supports multiple packages by default TCP / IP of 4096 bytes. For example, if the customer sends or receives large amounts of data, a larger packet size can improve performance and results in fewer network reads and writes. The default value for the option network packet size is 4096 bytes. Microsoft does not recommend this option, because for most applications, the packet size of 4096 bytes by default the best.
You can fill factor in the appropriate value.
The fill factor indicates how full SQL Server makes each index page. If no free space to create a new row in the index page, SQL Server creates the new page and transfer some rows from the previous page to the news. This process is called page splits. You can set the number of page splits by reserving the fill factor option, a suitable place on each index page. The fill factor is a value from 1 to 100 indicating the percentage of the index page is blank. The default fill factor 0. It is similar to a case like a fill factor of 100, the difference is that SQL Server leaves some space at the tip of the index tree for FILLFACTOR = 0. The fill factor percentage is used only when creating the index. If the table contains read-only data (or data that changes only very rarely) you can consult the fill factor to 100. If data is changed from the table, often the can lower fill factor and 70 percent, for example.
Can increase the memory of minutes per visit, to improve the performance of queries, the hash or sort operations, if the SQL Server has a large amount of memory available and there are many queries running concurrently on the server. SQL Server automatically assigns a minimal amount of memory in this configuration is. Memory min per query The default value is equal to 1024 Kb
You can increase the max async IO option if the SQL Server is running on a server disk subsystem performance, high-speed intelligent high (such as hardware-based RAID with 10 disks).This option specifies the maximum number of requests to disk I / O asynchronous to the entire server can issue against a file. In fact, async max IO supports SQL Server option not in SQL Server 2000.
You can change the option network packet size ‘to the appropriate value. This option can improve performance on networks whose base topology supports multiple packages by default TCP / IP of 4096 bytes. For example, if the customer sends or receives large amounts of data, a larger packet size can improve performance and results in fewer network reads and writes. The default value for the option network packet size is 4096 bytes. Microsoft does not recommend this option, because for most applications, the packet size of 4096 bytes by default the best.
You can fill factor in the appropriate value.The fill factor indicates how full SQL Server makes each index page. If no free space to create a new row in the index page, SQL Server creates the new page and transfer some rows from the previous page to the news. This process is called page splits. You can set the number of page splits by reserving the fill factor option, a suitable place on each index page. The fill factor is a value from 1 to 100 indicating the percentage of the index page is blank. The default fill factor 0. It is similar to a case like a fill factor of 100, the difference is that SQL Server leaves some space at the tip of the index tree for FILLFACTOR = 0. The fill factor percentage is used only when creating the index. If the table contains read-only data (or data that changes only very rarely) you can consult the fill factor to 100. If data is changed from the table, often the can lower fill factor and 70 percent, for example.
Tags: "sql server 2000" "queries running", Async, Disk Subsystem, free code php sql server 2000, Free Space, Hash, High Speed, Index Page, Maximum Number, Memory, Network Packet, network settings to improve performance in sql server, optimazition, Optimization Tips, Packet Size, Queries, Server Disk, Server Option, Server Settings, Server Sql, Sort Operations, Splits, SQL, Sql Server 2000, sql server optimization tips, sql server settings optimization, Suitable Place, tips, tips to handle large amount of data in sql server
This entry was posted on January 5, 2011 at 10:05 pm and is filed under SQL. You can follow any responses to this entry through the RSS 2.0 feed.
