Improve SQL Server database performance from outside

How do you improve the performance of your SQL Server database? The author thinks that we should follow the order from outside to inside to improve the running performance of the database. The following figure:

First layer: network environment.

To the enterprise to meet the database reflection speed is relatively slow, the first thought is whether the network environment caused. Rather than start thinking about how to improve the performance of the database. This is a mistake for many database administrators. Because when the network environment is very bad, you even how to improve the performance of the database, but also in vain.

such as a previous customer, to the author to reflect the database response time is relatively long, let me give them a database to improve the performance of the solution. At that time, the author felt very strange. As far as I know, this customer database is not a very large number of records. Also, they are configured with a good database server hardware. I also deliberately ran to their enterprises to see the cause of the problem. A look at the original network environment caused. The enterprise has more than 200 clients and is connected using hubs. This causes the enterprise internal network broadcast overflow, network congestion. And because there is no enterprise-class anti-virus software deployed, the network internal client computer virus, plundering a certain amount of bandwidth. Not only the database system response speed is relatively slow, and other applications, such as mailbox system, speed is not ideal.

In this case, even if it takes 10 times times more effort to improve the performance of the SQL Server database, the bamboo basket is empty. Because now the performance bottleneck of database server is not the database itself, but the network environment of the enterprise. SQL Server database performance is not improved if the network environment is not effectively improved.

To this end, the author suggested that the enterprise, want to talk to their network administrator, to see how to improve the network environment, reduce broadcast packet and network conflict, and effectively remove the local area network virus, Trojans and so on. Three months later, when I went back to the client, they reflected a great improvement in database performance. and other application software, performance has also improved.

Therefore, when the enterprise encountered a sudden decline in database performance, the first response is to look at the network environment, to see if there is a deterioration in fact. Only in this way can we walk less long way.