SQLGrease
@SQLGrease
We build performance monitoring software for SQL Server.
You might like
Every Twitter/x post I see is a question. Nobody just says what’s on their mind. Only people with good content seem to do that. If the post starts with what/how/who/why I scroll on now.
New blog post on synchronous stats updates: blog.sqlgrease.com/statman-querie…
blog.sqlgrease.com
STATMAN queries causing you timeouts? - SQLGrease SQL Server Performance tips
If you see statman queries showing up they can be causing you slowness with synchronous statistics updates. This post shows what to look for and how to enable asynchronous statistics updates.
If you use sys.dm_exec_requests or sysprocesses to look at sessions this post explains what the status column means:blog.sqlgrease.com/what-does-the-…
blog.sqlgrease.com
What does the status column of a session mean in SQL Server? - SQLGrease SQL Server Performance tips
You might notice there is a status column when you look at active executing requests in either sys.dm_exec_requests, sys.dm_exec_sessions, or sysprocesses. The status column indicates a general...
Announcing that @SQLGrease is now a Silver Level Sponsor for #SQLSatJax on May 4th, 2024. Thank you! #SQLSatJax1068 @sqlsatofficial sqlsaturday.com/jax sqlgrease.com
Ever have a performance problem due to a hint someone added and you need to remove it without changing code? blog.sqlgrease.com/removing-a-tab…
blog.sqlgrease.com
Removing a table hint without changing code - SQLGrease SQL Server Performance tips
On occasion I’ll run into a production performance problem where hints were added to a query and the hint is having a negative effect on performance. In some cases this is the result of something...
New blog post on adding hints to a query with query store. Spoiler alert, some hint types aren't supported: blog.sqlgrease.com/adding-hints-t…
blog.sqlgrease.com
Adding hints to queries with query store - SQLGrease SQL Server Performance tips
With SQL Server 2022, Azure SQL Database, or Azure Managed Instances you can now add hints to queries via Query Store.
Tuesday Roundtable youtube.com/watch?v=-v-ppq… Content by @zimmergren @SQLGrease @LuchoPorPista @Alex_TheAnalyst @ElizabethOldag @j0hnnyw1nter @MrAndyCutler @DataMozart @hellosqlkitty @JoshLuedeman @SQLBalls @nodestreamIo @DBABullDog @neeraj_jhaveri
Post on forcing plans for non parameterized SQL: blog.sqlgrease.com/query-store-an…
blog.sqlgrease.com
Query store and plan guides for non parameterized SQL - SQLGrease SQL Server Performance tips
forcing plans on non parameterized sql
Thank you so much to the @sqlsatboston team. You guys put on a great event. #sqlsatboston
Wrapping up deploying a new feature which detects and helps diagnose unsargable predicates. Just in time for the new year!
Thanks to @sqlgrease for sponsoring SQL Saturday Denver 2022. Register to come in person on Sep 17 at sqlsaturday.com/denver You can watch Migrating to Azure SQL Database and learn about the PaaS service first thing in the morning
If you've ever run into negative session IDs this will explain why: blog.sqlgrease.com/negative-block…
10 days left #SQLSatJax!! @unfComputing @SNICompanies @CozyRoc @Tintri @FultonAnalytics @PureStorage @onecallcm @ProCureSQL @dbWatch @SQLGrease @mssqltips @OReillyMedia @datavail @SIOSTech @Quest @OctopusDeploy @PavilionData @redgate @heimdalldata @Microsoft @Idera_Software
Two new posts regarding tuning queries that are looking for the first X number of characters or last X number of characters: blog.sqlgrease.com/improving-perf… blog.sqlgrease.com/improving-perf…
Post on how the new parameter sniffing option can help parameterized wildcard queries: blog.sqlgrease.com/performance-of…
United States Trends
- 1. #heatedrivalry 45.9K posts
- 2. #BTCCBestCEX 6,902 posts
- 3. Expedition 33 200K posts
- 4. shane 64.3K posts
- 5. ilya 49.2K posts
- 6. Kyle Pitts 19.2K posts
- 7. Falcons 38.3K posts
- 8. #TheGameAwards 417K posts
- 9. Bucs 24K posts
- 10. Todd Bowles 5,823 posts
- 11. GOTY 65.5K posts
- 12. Mega Man 37.4K posts
- 13. Baker 23.5K posts
- 14. Kirk Cousins 6,332 posts
- 15. jacob tierney 2,551 posts
- 16. Leon 187K posts
- 17. #KeepPounding 2,360 posts
- 18. Sonic 85.2K posts
- 19. Mike Evans 10.5K posts
- 20. Geoff 68.2K posts
Something went wrong.
Something went wrong.