Skip to content

SQLGrease SQL Server Performance tips

Performance tuning tips from the SQLGrease team

  • Blog Home
  • About Me
  • Contact Me
  • SQLGrease Home Page

Always On Availability Groups

Connecting to a read only replica with SSMS

February 3, 2022February 3, 2022 ~ franklinyamamoto

If you are using always on availability groups and need to connect to a read only replica, you might get the following error message in SSMS: Msg 978, Level 14, State 1, Line 1 The target database (‘Database’) is in an availability group and is currently accessible for connections when the application intent is set […]

Read More

See how SQLGrease can help fix your deadlocks

 

Subscribe to our mailing list

* indicates required

Follow @sqlgrease

Recent Posts

  • How to measure query runtime when developing/testing – part 2
  • How to measure query runtime when developing/testing – part 1
  • OLEDB waits: what they mean and a few ideas on addressing them
  • STATMAN queries causing you timeouts?
  • What does the status column of a session mean in SQL Server?
  • Query store queries losing forced plans
  • Removing a table hint without changing code
  • Adding hints to queries with query store
  • Query store and plan guides for non parameterized SQL
  • 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
~