Tag Info

New answers tagged


From SQL 2012 onwards, single_pages_kb got replaced by pages_kb in that DMV. https://msdn.microsoft.com/en-us/library/ms175019.aspx?f=255&MSPPError=-2147217396 So if you want to run the query included in the question, on a 2012+ server, remove the single_ string.


I wish the creator of that tool would toss that line. It unnecessarily scares people. And the number it gives is both too small and too large. But, in your case, it there is a real danger. If you had just 3 queries running that were nasty enough, they could be asking for 2.4GB -- more than your RAM!! This is because tmp_table_size and ...

Top 50 recent answers are included