Free SQL Server Learning - Get a six month training plan for the Accidental DBA
solving sql server problems for millions of dbas and developers since 2006



SQL Server DBA Tips SQL Server Developer Tips SQL Server Business Intelligence Tips SQL Server Career Tips SQL Server Tip Categories SQL Server Tutorials SQL Server Webcasts SQL Server Whitepapers SQL Server Tools SQL Server Questions and Answers MSSQLTips Authors About MSSQLTips SQL Server User Groups SQL Server Events I am MSSQLTips MSSQLTips Advertising Options

MSSQLTips Facebook Page MSSQLTips LinkedIn Page MSSQLTips RSS Feed MSSQLTips Pinterest Page MSSQLTips Twitter Page MSSQLTips Google+ Page






















Top SQL Server Tools

























Performance Tuning Tips

Configuration
  Identify SQL Servers with inefficient power plans using Policy Based Management
  SQL Server Simple and Forced Parameterization
CPU
  Find out which SQL Server instance is consuming most of the CPU
  How to find out how much CPU a SQL Server process is really using
  How to Identify SQL Server CPU Bottlenecks
Development
  Avoid SQL Server functions in the WHERE clause for Performance
  Collecting and Storing Poor Performing SQL Server Queries for Analysis
  Convert Implicit and the related performance issues with SQL Server
  Do SQL Server User Defined Datatypes (UDT) affect performance?
  Improving SQL Server performance when using table variables
  Removing Function Calls for Better Performance in SQL Server
  Speed up SQL Server queries with PREFETCH
  SQL Server 2008 64bit Query Optimization Trick
  SQL Server performance tuning for each layer of an application
  Trick to Optimize TOP clause in SQL Server
  Using schema binding to improve SQL Server UDF performance
Hints
  Optimize Parameter Driven Queries with SQL Server OPTIMIZE FOR Hint
Indexing
  SQL Server Schema Binding and Indexed Views
IO
  Gather IO statistics down to the SQL Server database file level
  Getting IO and time statistics for SQL Server queries
  How to Identify IO Bottlenecks in MS SQL Server
  Perfmon Counters to Identify SQL Server Disk Bottlenecks
Locking
  Finding SQL Server Deadlocks Using Trace Flag 1222
  Identifying Key and RID Lookup Issues and How to Resolve
  Remove some SQL Server blocking issues with the NOLOCK hint
Memory
  How to Identify Microsoft SQL Server Memory Bottlenecks
  Troubleshooting SQL Server RESOURCE_SEMAPHORE Waittype Memory Issues
Perfmon
  Automate Performance Monitor Statistics Collection for SQL Server and Windows
  Collecting performance counters and using SQL Server to analyze the data
  Correlating Performance Monitor and SQL Server Profiler Data
  Creating SQL Server performance based reports using Excel
  How To Collect Performance Data With TYPEPERF.EXE
  Setup Performance Monitor to always collect SQL Server performance statistics
  SQL Server Database Specific Performance Counters
  System Monitor (Perfmon) Counters for SQL Server 2005
  Trending Buffer Pool Performance Using DMV sys.dm_os_performance_counters
  Windows Reliability and Performance Monitor to troubleshoot SQL Server
Plan Cache
  Always have a good plan! What's in your SQL Server Plan Cache?
  Analyzing SQL Server Plan Cache Performance Using DMVs
  Analyzing the SQL Server Plan Cache
Processes
  SQL Server statements currently running with fn_get_sql
Shrink
  Issues with running DBCC SHRINKFILE on your SQL Server data files
SQLDIAG
  Introduction to SQLDIAG for SQL Server Performance Monitoring and Tuning
  Tool to help you analyze SQL Server SQLDIAG and PSSDIAG output
Statistics
  How to create a SQL Server Clone Statistics Only Database
  Interesting example of statistics and index usage on a SQL Server computed column
  Issues Caused by Outdated Statistics in SQL Server
  NORECOMPUTE option of UPDATE STATISTICS in SQL Server
  Performance Advantages of SQL Server Filtered Statistics
Tools
  Built in Performance Reports in SQL Server 2005
  More intuitive tool for reading SQL Server execution plans
  SQL Server Performance Monitoring Tools
Troubleshooting
  Troubleshooting Performance Problems in SQL Server 2005
Tuning Advisor
  Error running the SQL Server Database Tuning Advisor for non SA users
  SQL Server Database Engine Tuning Advisor for Performance Tuning
Tutorials
  SQL Server Graphical Query Plans Tutorial
  SQL Server Performance Tuning and Monitoring Tutorial
Wait Types
  A closer look at CXPACKET wait type in SQL Server
Whitepapers
  The High Performance SQL Server DBA
  Top 10 Tips for Optimizing SQL Server Performance
  Waiting on Waits

 

Sponsor Information
Find and fix SQL Server problems before they happen - SQL diagnostic manager now with predictive analysis!

NEW! Top 5 hard-earned lessons of a DBA from Grant Fritchey & the DBA Team. Read it now

What grade do you think your SQL Servers get? Find out with a SQL Server Health Check consultant in the USA.

Unlock the power of the Transaction log to discover unauthorized changes and recover lost data

Demystify TempDB Performance and Manageability

Copyright (c) 2006-2013 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | user groups
Some names and products listed are the registered trademarks of their respective owners.

Edgewood Solutions LLC | MSSharePointTips.com | MSSQLTips.com