Microsoft SQL Server Consultant
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.
Every time I do a performance training class I share some stories about those long running reports that I was able to speed up by simply switching a Table Variable (declared with the @ sign) to a Temp Table (declared with the # sign). Today I was working on a batch of TSQL code that took about 8 minutes to …
We hope you enjoyed our 10 days of Database Health Monitor Reports. We enjoy making your job easier! To it even easier we’ve created this blog post with all 10 days listed. Don’t have Database Health Monitor? Learn more about it. Day 1 – Database By Size The databases by size report is a quick and easy way to see …
Here listed is the current percentages of SQL server versions running our Daily Check up with Database Health Monitor. Compare this month’s percentages to Last Month’s Percentages What does this post mean?? We offer a service called SQL Daily Checkup. The pie chart above represents all of our current customers using our service and what SQL Server versions they are running. What …
SQL Daily Monitoring – SQL Server Versions for March Read more »
New SQL Server Course Release Track Blocking Queries Course Release! Using our instruction and scripts included in this course you will successfully configure email notifications when blocking occurs. Address blocking BEFORE it takes down your system. Enroll in this course for $24.99 >>> With Coupon Code >>> FEB-RELEASE50 … Read more… Day 1 – Database by Size 10 Days of …
Last Saturday Dave and I had a fun talk about SQL Server, developers, DBAs, ransomware and Database Health Monitor on his show Rockin’ the Code World. Below is the recording of our episode and hope you enjoy. And make sure check out some of his other chats with other professionals around the world.
Here you have all of Steve Stedman’s SQL Server tips, announcements and news posts of December. Hot Topics: Rockin’ the Code World – January 8th – LIVE! I am happy to announce that on January 8th, I have the privilege of a being a guest on the Rockin’ the Code World show with DotNetDave. Please join the show on January …
SQL Server Cyber Week Surprise! It’s Cyber Week at Stedman Solutions All SQL Server Courses are 30% off – Nov. 29th – Dec. 5th Use Coupon Code at Checkout : CYBERSALE30 Now’s Your Chance – Course Open For Enrollment Our SQL Server Backup and Recovery Course is ready for students! Priced at $99/year or $179/lifetime access (scroll down for sale …
Just Released! – Using Database Health Monitor Course Wed, 27 Oct 2021 Thousands of people are using Database Health Monitor but there can be a learning curve. So we’ve come up with a way to speed up the learning curve. You will learn most everything that you want to know about database…. Read more… Informational Ransomware Video Tue, 26 Oct …
Take the following sample code. Four similar tables with an INT IDENTITY, BIGINT IDENTITY, and two with UNIQUEIDENTIFIERS, one using newid() and the other with newsequentialid(). Once the tables are created and we insert 100,000 rows into each, they are very similar, but they take up very different amounts of disk space. Using the Database Health Reports application, we …
Should I Use A Unique Identifier As A Primary Key? Read more »
TSQL Pivot Table TSQL Pivot Table? What’s that? Here is a quick sample of how to implement a pivot table in TSQL for SQL Server. The example below creates a database called pivot, you probably already have your own database to work in. Then it… Read more… Excited to Release Training Videos Just this week the team at Stedman Solutions …