简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

怎样获得SQL Server的优化性能？

WBOY
Release： 2016-06-07 17:46:40
Original
1118 people have browsed it

为了最大程度优化SQL Server的性能， 首先您必须确定几个方面。当这几个方面得到优化时，可以最大程度的提高整个系统性能。然后您可以针对这几个方面进行分析。否则，您可能事倍功半。
经验证明，SQL Server的性能提高主要取决于逻辑数据库设计，索引设计和查询设计。 反之，最大的性能问题也往往源于这几个方面的设计缺陷。 如果数据库性能是一个关注焦点，您应该首先着眼这几个方面，因为在此的很小的投资可以带来很大的利益。
而其它系统级的性能问题， 例如内存、高速缓存、 硬件等， 的确值得研究。经验证明系统在这些方面容量越大，性能越高。 SQL Server对现有硬件资源采用自动方式管理，从而减少系统级的手工调整

Related labels：
server sql
source：php.cn
Previous article：SQL查询 Next article：一条SQL语句，选择从第M条到第N条数据
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
XAMPP/SQLSRV: Unable to find Sqlsrv in PHPINFO(); - error from connection I'm trying to connect to my SQLServer database hosted on a LinuxVM. I'm running xampp on m...
From 2023-11-09 22:34:33
0
1
172
How to add cache control in generated static files (Nuxt 3) I'm using Nuxt3 to create an SSR project. I'm thinking of adding a Cache-Control header to...
From 2023-11-05 08:55:14
0
2
287
Nuxt 3: useAsyncData and $fetch only work once I'm using nuxt3 in a project and I want to make a request to a typescript file in the /ser...
From 2023-11-04 00:03:52
0
1
270
How to use useQuery() as API route parameter in Nuxt 3? I'm following a guide where the api route is built like this: 1 create the server/api/rout...
From 2023-11-01 19:50:53
0
2
339
Install/enable php8.1's sqlsrv and pdo_sqlsrv drivers on ubuntu20.0 I'm trying to enable the sqlsrv driver for php8.1 on Ubuntu20.0. It doesn't show the exten...
From 2023-11-01 11:06:13
0
2
283
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！