This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Dec2

SQL SERVER – MemoryGrantInfo Property Explanation

Pinal Dave
SQL Performance
SQL Memory, SQL Scripts, SQL Server 2019
1 Comment

I have been writing about the Memory Grant Feedback feature. Today we will discuss various properties of MemoryGrantInfo in this blog post.

Continue Reading
Dec1

MemoryGrantInfo – What are Different Status of IsMemoryGrantFeedbackAdjusted? – Interview Question of the Week #253

Pinal Dave
SQL Interview Questions and Answers
SQL Memory, SQL Server
No Comments

Question: What are Different Status of IsMemoryGrantFeedbackAdjusted (MemoryGrantInfo Property)? Today we will see a consolidated answer to this question.

Continue Reading
Nov30

Stop Memory Grant Feedback: Database Setting and Query Hint

Pinal Dave
SQL Performance
SQL Memory, SQL Scripts, SQL Server Configuration
No Comments

To stop memory grant feedback, use the hint or the setting that matches the mode of the plan. A tested demo shows that a row mode hint keeps a grant at 13,256 KB, while a batch mode hint changes nothing for a row mode sort. The post also corrects the setting names and shows the persistence switch.

Continue Reading
Nov29

Memory Grant Feedback Loop: When SQL Server Stops Adjusting

Pinal Dave
SQL Performance
Execution Plan, SQL Memory, SQL Scripts
2 Comments

The memory grant feedback loop adjusts a grant after every run, and a query whose needs swing can send it back and forth. In a tested demo SQL Server stops adjusting on run 33 and falls back to its first grant. The post also shows what SQL Server 2025 does by default.

Continue Reading
Nov28

IsMemoryGrantFeedbackAdjusted Values: What Each Status Means

Pinal Dave
SQL Performance
Execution Plan, SQL Memory, SQL Scripts
No Comments

IsMemoryGrantFeedbackAdjusted values tell you what SQL Server did with the memory grant of one run. A tested demo produces every status: first execution, accurate grant, adjusting, stable, percentile adjusting and feedback disabled. The post also shows which run each status appears on.

Continue Reading
Nov27

Memory Grant Feedback Explained: How SQL Server Learns

Pinal Dave
SQL Performance
Execution Plan, SQL Memory, SQL Scripts
6 Comments

Memory grant feedback explained with one small demo. A sort asks for 13256 KB, uses 160 KB, and gets a corrected grant of 1536 KB on the next run. The post also shows how to read the status in the plan and what the feature needs.

Continue Reading
Nov26

Task Manager Update Speed: Why the CPU Graph Looks Stuck

Pinal Dave
SQL Tips and Tricks
SQL CPU, SQL Scripts, Windows
1 Comment

Task Manager update speed controls how often the CPU graph moves. When it is set to Paused, the graph freezes and a normal server can look like it has a CPU problem. This post shows the fix and a five second test in T-SQL that tells you whether the graph is alive.

Continue Reading
Previous 1 … 137 138 139 140 141 142 143 … 846 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com