Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guidance

By Steve Jones,

How do you manage SQL Server? Do you have a list of rules that tell you when x happens, you do y. Or if y doesn't solve the problem, you do z? Some of you have guidelines like that, though it's likely that the way you solve problems is somewhat internalized and you adjust your "rules" or "steps" based on the situation. Do you reduce or increase parallelism when you have high CPU? Either change might be the solution, depending on the causes of an issue.

SQL Server is complex. We can't easily reduce the solutions to problems to a set of rigid protocols that ensure optimal performance. If we could, there truly wouldn't be as much of a need for DBAs as there is. Consultants and experts are well paid, and often very busy precisely because SQL Server is not so easy to tune and optimize in many organizations.

That's a bit of the point I saw in Grant Fritchey's "Be Cautious Offering Guidance" piece this week. When trying to help someone improve performance, or reduce issues, or anything else, you can't often give someone a rule of thumb that just works. You can't give them a one sentence solution. Most things in life aren't that simple, and neither is working on SQL Server.

The environment in which your application runs is complex and there are lots of variables that can affect the advice or guidance that an expert might recommend. It's the reason we see DBAs often saying "it depends."

Because it does.

 
Total article views: 99 | Views in the last 30 days: 1
 
Related Articles
FORUM

SQL Server won't start - can't find mssqlsystemresource.mdf

SQL Server won't start - can't find mssqlsystemresource.mdf

FORUM

Can't reduce fragmentation below 66.67%

Try to reduce index fragmenation...

BLOG

Detecting and Reducing VLFs in SQL Server 2008/2008 R2 Transaction Log Files

One common, but often undetected issue that I see with SQL Server databases is a very high number of...

ARTICLE

Reducing Round Trips

One of the best ways to reduce the load on your server and increase application responsiveness is to...

FORUM

Report Server Authentication Problem

Report Server Authentication Problem

Tags
database weekly    
editorial    
 
Contribute