8 Kicks

SQL SERVER – Queries Waiting for Memory Allocation to Execute(blog.sqlauthority.com)

submitted by pinaldavepinaldave(9662) 2 years, 7 months ago

In one of the recent projects, I was asked to create a report of queries that are waiting for memory allocation. The reason was that we were doubtful regarding whether the memory was sufficient for the application. The following query can be useful in similar case. Queries that do not have to wait on a memory grant will not appear in the resultset of following query.

add a comment |category: |Views: 191

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
jeetjeet(0) - dotnetterdotnetter(0) - BagavathiBagavathi(150) - riddle12460riddle12460(0)
More who kicked this story...
Comments:

No comments so far

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?