Tuning expert makes SQL Server faster

01 January,2014 by Jack Vamvas

SQL Server Consultant -  Performance Tuning

Contact jack@sqlserver-dba.com

Faster SQL Server : SQL Server 2014 \ 2012 \ 2008 R2 \ 2008 \ 2005 \ 2000

Structured reporting , analysis, resolution >>>> Faster SQL Server

Focus on the queries causing the largest bottlenecks. Hardware is rarely the root cause. I analyse hundreds of issues every week , and most  are resolved through non-hardware solutions . Applications  relying on database servers are complex. Knowing  how to identify the top SQL Server bottlenecks and resolve leads to a fast SQL Server – saving money on hardware upgrades and expensive database changes.

I gather information from your SQL Server. I apply a root cause analysis using techniques and experience gathered over 17 years of SQL Server experience.

 

SQL Server Performance Killers – Sound familiar?


1.Incorrect plan used by Stored Procedure
2.No indexes
3.Inefficient queries – Bad estimates causing has joins and index scan
4.Inaccurate\missing statistics
5.To much data retrieval . Not using WHERE clauses
6.DBAs  relying on Perfmon rather than SQL Server Profiler to troubleshoot SQL Server Performance Problem
7.Using cursors rather than set based T-SQL
8.Slow performance on SQL Transaction Logs causing serious bottlenecks
9.SQL Data file autogrow causing transactions to stall
10. Starving the OS of memory due to poor memory configuration on SQL Server
11.Placing all databases on the same drives causing IO delay issues
12.Executing bulk imports at Production peak times causing performance issues.
13.Using SQL Server triggers and following best practises, particularly using nested or recursive triggers 14. DBA not performance testing a new disk subsystem
15.DBA relying on the “Kill it by Iron” approach. Not attempting to find the bottlenecks
16.Queries not hitting indexes and forcing scans, when using VARCHAR(max)
17.AntiVirus scanning database files
18.Screensavers with intensive CPU usage
19.High levels of blocking and deadlocking
20.High row count estimates  causing hash joins with table/index scans , result:high CPU

Use a real SQL Server Tuning expert with proven track record and experience

Do you need a SQL Server Health Check?

Do you have slow performance after a SQL Server upgrade?

Do you want a SQL Server certification against best practises?

Contact jack@sqlserver-dba.com


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Tuning expert makes SQL Server faster


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer