Abstracts submitted to SQL Saturday
I just submitted abstracts to SQL Saturday #114 in Vancouver and #108 in Redmond. The Redmond SQL Saturday appears to be the more popular of… Read More »Abstracts submitted to SQL Saturday
Blog posts relating to SQL Performance Tuning.
SQL Server tuning is the process of optimizing the database’s configuration, queries, and infrastructure to ensure the system runs as efficiently as possible. The goal is to reduce resource usage, increase query speed, and improve overall system responsiveness. Performance tuning involves analyzing server performance metrics, identifying bottlenecks, and implementing solutions that range from hardware upgrades to query rewriting. These optimizations are crucial for maintaining a smooth user experience and supporting business-critical applications.
A key aspect of performance tuning is query optimization. Poorly written SQL queries, missing indexes, or incorrect indexing strategies often lead to slow query execution. By using tools such as execution plans and SQL Profiler, DBAs can identify and correct inefficiencies in SQL code. Techniques like index tuning, query rewriting, and partitioning can drastically reduce query execution times. Regularly updating statistics and reorganizing or rebuilding indexes further enhances query performance and ensures accurate query plans.
Beyond queries, performance tuning also focuses on the SQL Server environment itself. Configuring server settings, adjusting memory allocation, and fine-tuning I/O operations play a significant role in optimizing database performance. Monitoring tools like Database Health Monitor (available at DatabaseHealth.com) provide insights into server health and potential issues. Stedman Solutions offers comprehensive SQL Server performance tuning services, combining years of experience with specialized tools to ensure your SQL Server environment performs at its peak. Learn more about our managed services at Stedman Solutions.
I just submitted abstracts to SQL Saturday #114 in Vancouver and #108 in Redmond. The Redmond SQL Saturday appears to be the more popular of… Read More »Abstracts submitted to SQL Saturday
Over the last couple of weeks I have taken a couple of the common queries that I use to analyze the health of a SQL… Read More »New – SQL Server Health report
Is it a good idea to run DBCC SHRINKDATABASE regularly? Download the sample file ShrinkSample. This article and samples apply to SQL Server 2005, 2008,… Read More »Index Fragmentation and SHRINKDATABASE
The question comes up when looking at an execution plan of whats the difference between an index seek and an index scan. What it… Read More »Index Seek vs Index Scan
Just the same query that I posted months ago, but this time it is wrapped in a stored proc. I use this one often enough… Read More »Big One Time Use Queries – Revisited
There is a newer version of this posting, click here. Part of my regular database maintenance or tuning routine is to look for the queries… Read More »Big One Time Use Queries
Attached is the slide deck for a short presentation on indexing that was created to educate software developers on the basics of indexing. Outline: What… Read More »Indexing Presentation – The Basics
Cleaning up extra indexes, and implementing parameterized queries. I don’t know how many times I have had to explain the difference between a clustered index… Read More »More database performance tuning.
This week I started working at Emergency Reporting doing database performance tuning and scalability work. Currently this is a half time gig focused on SQL Server… Read More »Database Tuning at Emergency Reporting