How can I obtain the optimized performance of SQL Server?

To maximize the performance of SQL Server, you must first determine several aspects. When these aspects are optimized, the overall system performance can be maximized. Then you can analyze these aspects. Otherwise, you may get twice the result.
Experience has proved that the performance improvement of SQL Server mainly depends on the logic database design, Index design and query design. On the contrary, the biggest performance problem often stems from the design defects in these aspects. If the database performance is a focus, you should first focus on these aspects, because a small investment can bring great benefits.
Other system-level performance problems, such as memory, high-speed cache, and hardware, are indeed worth studying. Experience proves that the higher the capacity of the system, the higher the performance. SQL Server automatically manages existing hardware resources to reduce system-level manual adjustments