No intellisense for resource pool

torsten.strauss

Hi Redgate Team,

unfortunately, SQL Prompt will not show the available resource pools (and workloads). If I remember correctly, in a previous version this was supported.
Can you please fix it - thanks! 

CREATE RESOURCE POOL [pool_in-memory]

WITH

(

MIN_MEMORY_PERCENT = 65, MAX_MEMORY_PERCENT = 65

);

GO

DROP RESOURCE POOL [pool_in-memory]; -- pool list is not available...

Thanks!

Torsten
MVP

squigley

Hello Torsten,

Thanks for your inquiry and sorry to hear about your issue with SQL Prompt.

I was able to replicate this on my end, so I'll check on this with the developers and get back to you afterwards.

squigley

Hello Torsten,

Thanks for your patience with this as your issue should now be fixed in the latest version of SQL Prompt.

Can you try upgrading to see if that helps?

Download Link: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.10.4.26165.exe

Upgrade Documentation: https://documentation.red-gate.com/sp/upgrading

Thanks!