Viewing 9 posts - 1 through 10 (of 10 total)
Thanks for the response Jo.
The server has 960GB with the max memory for SQLServer set to 839GB. That along with no indications in the RING_BUFFER_RESOURCE_MONITOR of IndicatorsSystem with RESOURCE_MEMPHYSICAL_LOW make...
November 26, 2020 at 12:48 pm
Hi,
I repeatedly performed a SELECT from sys.database_permissions. You could probably do this manually, but I used a loop (see below). From memory, I think I had to run it a...
July 11, 2018 at 1:25 am
Hi,
Thanks to Jonathan Kehayias for mentioning that there is a known issue with SQLServer 2014:
https://support.microsoft.com/en-us/help/3115789/fix-memory-leak-occurs-in-the-memobj-sosnode-type-object-when-you-run-a-query-that-contains-sys.database-permissions-in-sql-server-2014
April 4, 2017 at 7:27 am
Hi,
A quick update. The server has been rebooted and things are looking more like you'd expect:
CPU - 0%
There are now thousands of plans in the...
March 23, 2017 at 8:47 am
Yes, that makes sense. As you say, unfortunately it’s a bit inconvenient – but luckily I have some other options to pursue in this case. 🙂
Thanks for your...
April 16, 2015 at 8:40 am
Your earlier comments nudged me in the right direction. 🙂
Yes, checked the QueryPlanHash and they were the same.
I’ve also managed to get access to a few more instances and I...
April 16, 2015 at 8:24 am
Thanks for the replies.
I've just done another quick test (just on one instance - 2008):
Created a table TEST (checked it's object_ID)
Executed a select against the table and got the query_hash...
April 16, 2015 at 7:30 am
This is a nice bit of code on smaller chunks of XML.
It might also be worth adding exec "sp_xml_removedocument @idoc" to the end of the procedure to free up memory.
April 8, 2015 at 1:51 am
If you just want a numbered list from a table you could use the ROW_NUMBER() function:
SELECT col1, ROW_NUMBER() OVER (ORDER BY col1)
FROM tablea
I've not used it much myself but it...
April 28, 2008 at 10:10 am
Viewing 9 posts - 1 through 10 (of 10 total)