Performance: String Concatenation in SQL Server
String Concatenation SQL Server is one of these things that might be sound until you try to concate longer strings. That is where it gets… Read More »Performance: String Concatenation in SQL Server
Performance
Blog posts relating to SQL Performance Tuning.
SQL Server Performance Tuning
Enhancing Database Efficiency
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.
How many files are in your SQL Error log directory?
I was investigating a slow sever recently and discovered almost a million files in the sql server error log directory. This contained job history and… Read More »How many files are in your SQL Error log directory?
User objects in the master database
Recently when doing a database upgrade for a client, I was informed that we had missed some user procedures, tables and functions in the master… Read More »User objects in the master database
Weekly Summary June 26, 2020
Biggest MessJune 25, 2020 As a DBA, what is the biggest problem or mess you have had to clean up in a SQL Server. If… Read More »Weekly Summary June 26, 2020
Update Statistics
Is there any safe way to ‘update statistics’ without causing major slow downs? As far as a safe way to update statistics. It is best… Read More »Update Statistics
Steve Stedman Blog Posts from 2019
Finding Serializable QueriesDecember 3, 2019 Serializable, and some of the other isolation levels can have performance implications. Recently I came across a case where I… Read More »Steve Stedman Blog Posts from 2019
SQL Performance Tuning
Do you need help with a slow running SQL Server? Take a look at these SQL Server performance tuning options that we offer. Stedman Solutions… Read More »SQL Performance Tuning
Do you need SQL Server Performance Tuning Help?
The team at Stedman Solutions, LLC (Steve, Bill, Derrick, and George) offer a variety of services, but one that I particularly enjoy is the performance… Read More »Do you need SQL Server Performance Tuning Help?
Q & A – Deleting lots of rows from a huge table.
The question came up as a blog comment of “To delete 100,000 row chunks from a 9,542,067 row table, how about” Thats a great question.… Read More »Q & A – Deleting lots of rows from a huge table.
DBCC FREEPROCCACHE – What is the impact.
Here is a question that I received from a friend today and I thought it would be a good post explaining the details: Steve, I… Read More »DBCC FREEPROCCACHE – What is the impact.