SQL Server Performance Baseline

Question

Hi All,

Anyone can recommend Performance Baseline for SQL Server (IO, CPU, Memory)? Best practices, threshold and process?

Thanks

GCE

Answer 1

Hi @GCE

I would say, "it depends" ;-)

What kind of application should be run on that SQL Server?

Is it a web shop, a Sharepoint, or a small room booking software?

What kind of workload does this application produce? Is it more compute-related or more IO related? Is it a self-developed or a legacy application?

Or is a SQL Server for a bunch of general applications?

Is it a VM (HyperV or VMWare or similar), or is it bare metal?

For example, follow the Microsoft documentation and/or read some blog posts like this:

[https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/sql-server-performance-tuning-nine-best-practices/

[https://www.sql-aus-hamburg.de/en/4-sql-server-configuration-implement-best-practices/

I hope my answer is helpful to you,

Your

Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!

Answer 2

include the disk utilization as well

FOR PRODUCTION

80 percent utilization would be warning alert

90 pervcent utilization would be critical alert

FOR DEVELOPMENT

90 percent utilization would be warning alert

95 pervcent utilization would be critical alert

Answer 3

Hi @GCE

Please refer to this article:
Performance Baselines And Benchmarks For Microsoft SQL Server

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.