Skip to content

The sp_what is a stored procedure that when executed gives you detailed information about what processes are executing and requesting memory grants. This allows you to see exactly what is going on, so you can fix the problem queries causing this condition.

License

Notifications You must be signed in to change notification settings

mfuller333/sp_what

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 

Repository files navigation

sp_what

The sp_what is a stored procedure that when executed gives you detailed information about what processes are executing and requesting memory grants.I am exposing the pre-calculated memory counters, as well as DOP and QueryCost.

This shows us exactly what is requesting how much memory, further allowing us to focus on the problem queries with large memory grants but low actual usage.

About

The sp_what is a stored procedure that when executed gives you detailed information about what processes are executing and requesting memory grants. This allows you to see exactly what is going on, so you can fix the problem queries causing this condition.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages