By using this site, you agree to the Privacy Policy and Terms of Use.

Stay Tuned!

Subscribe to our newsletter to get our newest articles instantly!

SQL: Performance Tuning Query

BY Valdy
21 February 2010
0 Comments
1.79K Views

Queries

— Basic setup

DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE

SET STATISTICS IO ON
SET STATISTICS TIME ON

/*
SELECT * FROM dbo.Categories
*/

Sources

Performance Tuning in SQL Server – http://www.youtube.com/watch?v=P97_oFfD218

Logical Read – http://www.sql-server-performance.com/articles/per/logical_reads_p1.aspx

Viewing Missing Indexes – http://webbtechsolutions.com/2010/02/23/viewing-missing-indexes-in-management-studio-2005/

Credits

Photo by Panumas Nikhomkhai: https://www.pexels.com/photo/close-up-photo-of-mining-rig-1148820/

[Note: Page views – 2,260 – before migrated from the Dewalist Blog website on 08/08/2020]

SQL Server 2005 Notes

Valdy

About Author

Valdy founded Dewacorp.com, a helpdesk and IT Services provider that has taken care of nearly 40,000 customer service requests in the past 15 years - nearly 2,600 per year. He also created the growing Dewalist.com - a classified website that has close to 110,000 page views and 9,000+ user visits per month with 61,000+ yearly published ads and 47,000 active registered users. He blogs for the ever-growing Dewapost.com, a tech blog that gets around 20,000 impressions per month with 700 clicks and 10 average pages first impressions on Google Search. You can reach him on the Contact Us page, social media links below or Dewachat.com.