Performance

External Article

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

Technical Article

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,871 reads

Blogs

T-SQL Tuesday #155 –The Dynamic Code Invitation

By

Apologies for the late invitation. A minor snafu has me hosting again. This is...

Daily Coping 6 Oct 2022

By

Today’s coping tip is to remind yourself that you are enough just as you...

What you can do is based on more than your direct permissions.

By

What you have access to is not just what you have direct permissions to....

Read the latest Blogs

Forums

SSRS REPORT

By RDOT

THIS IS THAT IS USED IN CRYSTAL REPORT AND I WANT TO  USE IT...

Problem extracting Data from JSON string

By Weegee71

Hi there I have a JSON sample and struggling to extract data from it....

I must be loosing my mind. Odd data issue

By Snargables

I have a guest table on two servers. Call them prod1 and prod2. The...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers