SQL Server default settings that you might want to change

  One very common complaint I receive from SQL Server administrators is: “Why is not SQLServer performing fine out of the box, with the default settings?”   My answer is that SQL Server is like a car. With the default settings it will run fine for most people. But if you want a racecar you…

0

Specialized Performance Troubleshooting (Part 3: How to identify storage issues at a SQL Server box)

This week I will explain how to detect and analyze storage performance issues. The first step is to collect a Perfmon trace and check these two counters for each disk:Physical Disk: Avg. Disk Sec/ReadPhysical Disk: Avg. Disk Sec/Read The recorded values should be less than 20 msec for attaining good performance. They will have to…

0

Specialized Performance Troubleshooting (Part 1: How to troubleshoot Forwarded Records)

This week I will discuss how to troubleshoot Forwarded Records issues.   What are Forwarded Records? If you have some time, you can read the full story at Paul Randal’s blog post: http://www.sqlskills.com/blogs/paul/forwarding-and-forwarded-records-and-the-back-pointer-size/ If not, I will tell you the short story: “They are a performance overhead that can occur when you insert rows into…

0