Performance

Using DBCC DROPCLEANBUFFERS When Testing Performance

  • Article

Over the years I've had many discussions with other SQL Server Database Administrators as to whether or not you should have the database buffer pool loaded with data pages or empty when testing queries for performance. This tip will take a look at the effects on query performance for both cases by using the DBCC DROPCLEANBUFFERS statement to empty the buffer pool.

2014-06-20

8,763 reads

SQL Server CPU Usage History Histogram

  • Script

Returns a summary of CPU usage by SQL Server over the last 4 hours (default).

Using the sample values collected in the dm_os_ring_buffers dmv, this query will show CPU usage by the SQL Server process for the last for hours even if you have no other benchmarking activities in place on your server yet.

4.75 (16)

2015-09-18 (first published: )

4,441 reads

Blogs

Inspector V2.6 now available

By

As always the code can be found here in our github repoWe updated our...

Data Mesh: Centralized ownership vs decentralized ownership

By

I have done a ton of research lately on Data Mesh (see the excellent...

Daily Coping 23 Jul 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Define All The Steps Up Front

By Grant Fritchey

Comments posted to this topic are about the item Define All The Steps Up...

Having users access .dtsx (package file) saved on LAN

By redoak

Hello All, I created a package file (.dtsx) via SSDT. I took the folder...

AG is continually reporting failover due to mirroring connect error

By webrunner

Hello experts, I'm seeing this Always On Availability Group behavior around every 5 minutes....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers