Skip to content

SQLGrease SQL Server Performance tips

Performance tuning tips from the SQLGrease team

  • Blog Home
  • About Me
  • Contact Me
  • SQL Grease Home Page

extended events

How to detect query timeout errors with Extended Events

November 29, 2017December 31, 2019 ~ franklinyamamoto ~ 6 Comments

A common error that pops up in application logs as a result of long executions is: When these start showing up in an application log, it is a good indicator that a performance issue may be occurring in SQL Server.  So far as SQL Server is concerned, it thinks the application dropped or cancelled the […]

Read More

Is your system_health session missing data?

November 20, 2017June 3, 2018 ~ franklinyamamoto

It is fairly common knowledge that the system_health session is a useful tool for resolving issues such as deadlocks.  I see a lot of posts on other websites where people report a discrepancy in the number of deadlocks monitored by perfmon or tracing vs what shows up in the system health session. This is the result […]

Read More

See how SQLGrease can help fix your deadlocks

 

Subscribe to our mailing list

* indicates required

Follow @sqlgrease

Recent Posts

  • Filtered indexes and the new parameter sniffing option (spoiler alert it doesn’t help)
  • Negative blocking session ids
  • Query store doesn’t work on read replicas
  • Improving performance of your RIGHT query
  • Improving performance of your LEFT query
  • Perform RTRIM and LTRIM in your code not in your queries
  • Performance of parameterized LIKE queries with new parameter sniffing option
  • Don’t use UPPER in WHERE unless you really need it
  • Estimate rows Vs Estimated rows to be read what’s the difference
  • Performance implications of using DATEDIFF function in WHERE
  • Performance implications of using ISNULL vs IS NULL
  • Connecting to a read only replica with SSMS
  • Index seeks on date and CONVERT
  • Fixing an implicit type conversion without a code change
  • Dealing With “Bad” Plans
  • Making Queries With Leading Wildcards Faster
  • Creating a database per customer VS single database for all customers (SQL Server)
  • What’s filling up tempdb?
  • Plan guides made easy
  • Tuning Substring Query Without Changing the Query
~