I have a 64GB Windows Server 2019 Standard server in my TEST Server. I have SQL Server 2019 CU9 Developer Edition and my the instance is consuming 21,199 MB as shown in sql_physical_memory_in_use_MB. I have 4 user databases.  Their sizes are approximately 5GB, 2GB, 400MB, and 200MB. My tempdb is configured to be 8GB at instance start-up. I'm trying to understand why my instance is using 21GB of memory.  Just worried about a possible memory leak. Can anyone calm my nerves? SELECT     (CASE WHEN ([database_id] = 32767) THEN 'Resource Database' ELSE DB_NAME (database_id) END) AS 'Database Name',     SUM(CASE WHEN ([is_modified] = 1) THEN 1 ELSE 0 END) AS DirtyPageCount,     SUM(CASE WHEN ([is_modified] = 1) THEN 0 ELSE 1 END) AS CleanPageCount,     count(*)AS TotalPageCount,     cast(count(*) * 8192.0 / (1024.0 * 1024.0) as decimal(8,2)) as BufferPoolMB FROM sys.dm_os_buffer_descriptors GROUP BY database_id ORDER BY TotalPageCount desc GO  OUTPUT     Database Name DirtyPageCount CleanPageCount TotalPageCount BufferPoolMB     SFI_WMS 55 805665 805720 6294.69   tempdb 18648 210842 229490 1792.89   DBAtools 483 82035 82518 644.67   Resource Database 0 3896 3896 30.44   msdb 42 1898 1940 15.16   master 24 766 790 6.17   ReportServer 4 476 480 3.75   ReportServerTempDB 0 308 308 2.41   model 0 245 245 1.91     SELECT      physical_memory_in_use_kb/1024 AS sql_physical_memory_in_use_MB,      large_page_allocations_kb/1024 AS sql_large_page_allocations_MB,      locked_page_allocations_kb/1024 AS sql_locked_page_allocations_MB,     virtual_address_space_reserved_kb/1024 AS sql_VAS_reserved_MB,      virtual_address_space_committed_kb/1024 AS sql_VAS_committed_MB,      virtual_address_space_available_kb/1024 AS sql_VAS_available_MB,     page_fault_count AS sql_page_fault_count,     memory_utilization_percentage AS sql_memory_utilization_percentage,      process_physical_memory_low AS sql_process_physical_memory_low,      process_virtual_memory_low AS sql_process_virtual_memory_low FROM sys.dm_os_process_memory;   OUTPUT     sql_physical_memory_in_use_MB sql_large_page_allocations_MB sql_locked_page_allocations_MB sql_VAS_reserved_MB sql_VAS_committed_MB sql_VAS_available_MB sql_page_fault_count sql_memory_utilization_percentage sql_process_physical_memory_low sql_process_virtual_memory_low     21199 0 0 124464 21461 134093263 9673913 100 0 0     SELECT c.value, c.value_in_use FROM sys.configurations c WHERE c.[name] = 'max server memory (MB)';      value value_in_use     60288 60288
As soon as I start SQL Server with no application querying, in the task manager it starts to consume memory very fast till it consumes around 15GB. How can I resolve this issue?
How to export data as CSV format from SQL Server using sqlcmd? Converting LAS 1.4 to 1.2 LIDAR files were released for major part of Slovenia few months back in zlas format. Decompressed LAS format is 1.4 version. I have tried many options how to generate DEMs and had some success in programs and tools but unfortunately they were all trial versions of license pay versions.  Problem is that I can't open and generate DEMs of LAS version 1.4 in many open and free tools (such as MCC-Lidar).   Can you help me converting LAS from 1.4 to 1.2 in some free tool? Or if it is any other way for LAS 1.4. Exposing database IDs - security risk? What is the best way to randomize an array of strings with .NET? My array contains about 500 strings and I'd like to create a new Array with the same strings but in a random order.  Please include a C# example in your answer. Windows registry entries for default explorer view I'm making an automated installer for Windows XP, and I want the default view to be the "details" view on all folders - that is, the effect gotten by setting one folder to the details view, then going to Tools -> Folder Options -> View -> "Apply to All Folders". I also want the status bar to be showing, same as going View -> Show Status Bar.  What registry entries should I modify, and to what, to have this be the case? Can anybody explain the UNABLE_TO_LOCK_ROW error? Maybe this question is too obvious to everyone.      In Noetherian ring $R$, ideal $I\subset R$, $P\in\mathrm{Ass}(I)$, then $P=I:a$ for some $a\in R$ where $\mathrm{Ass}(I)$ denotes associated primes of $I$.   This is an exercise 8.29 in Gathmann's Commutative Algebra notes. I am supposed to find this statement obvious. However, up to now, I still did not find this statement obvious. Can someone explain intuitively why noetherianness here allows me removing radical $\sqrt{I:a}$ without going into details?  If $Q$ is a primary ideal of $I$, then certainly $\sqrt{Q:a}=P$ for $a\not\in P$. It seems taking $(p_1,\dots, p_n)=P$, $p_i^{n_i}a\in Q$. Since $Q$ primary, I must have $p_i\in Q$ and $p_i^{n_i}\in Q$. (This argument seems very wrong as this deduces the same conclusion without noetherian property.) Do the last digits of powers of a number $n$ follow the same cycle as the last digits of the number $n$'s last digit's powers? has been edited by .   , see revisions 3 to 4.   Now what he did is totally inexplicable to me, as a matter of fact he destroyed the answer. The new version is neither syntactically valid nor does it make any sense.  Still, the edit got "peer-reviewed" and nodded off.  Is there any way to deal with these kinds of things, other than sighing heavily and rolling back the edit?  Rhetorical side question: Could this be a side-effect of people grinding for reviewer badges? Mean of a Cauchy Distribution Why $\sum_{k=0}^m x^k $ is equal to $\dfrac{x^{m+1}-1}{x-1} $? Who can help me proving this (but you can no longer use $\sum$ in the proof):  $$\sum_{k=0}^m x^k=\dfrac{x^{m+1}-1}{x-1}$$ Open a window on a remote X display (why "Cannot open display")? Why are Flash applications so sluggish/crashy? I've noticed that Flash applications tend to be more sluggish under Ubuntu than they do under Windows on the same machine. This is particularly noticeable when watching HD video or playing graphics/physics-heavy games. Are there any ways of improving the performance of Flash under Ubuntu, or is this just an issue with the Linux version that I will have to live with?  Currently I'm just cutting down on the number of tabs open, blocking flash ads, and closing other programs, but I'm looking for ways to affect Flash itself.  Other things I have already been doing include using Youtube's HTML5 feature and playing videos straight from /tmp in VLC. I was wondering if there was some way of streamlining Flash itself though. Perhaps not.  More Specific Question: Is there anything I can do in mms.cfg to boost performance? Often when I edit one of my answers, it's because I want to better address the original question. The only problem is that I can't see the original question while I'm editing my answer!  I'd love to see the original question text beneath the "answer edit" form. This way I could scroll down slightly to read it if I wanted to, or just ignore it if not.  Current workaround is to click the 'return to answer' link and hope that you remember to launch it in a new tab/window, then tab back and forth.    Imported from this uservoice item: Are we inside a black hole? How do I pre-install Ubuntu for someone (OEM install)? I would like to pre-install Ubuntu on a computer for someone. I may want to customize it for them, but in the end they need to be able to choose a username, password, etc. when they first boot it up. (Also called an OEM install).  How do I do this? How do people at Hogwarts usually tell the time? Classes and lessons at Hogwarts are presumably scheduled at fixed times of day. The first class might start, for example at nine in the morning.  To be on time for one's lessons, it is therefore crucial to know the current time but we know that electric watches of course do not work at Hogwarts because of all the magical interference. Are there magic watches? Is there maybe a spell to tell the time?  How do people at Hogwarts usually tell the time? Programming pattern to generate VGA signal with micro-controller? I want to generate VGA signal with micro-controller (like TI Tiva ARM which runs at 90/120Mhz speed).  I'm not sure how to make accurate timings with micro-controller. Which programming pattern I need to use?  Do I need any inline assembler code? How to wisely use interrupts?  Would be great if anybody show some pseudo code how to generate VGA signal.  I successfully generated VGA signal with FPGA. But I just can't figure out how to do it with MCU. Can you explain the "Axiom of choice" in simple terms? As I'm sure many of you do, I read the  webcomic regularly. The  involves a joke about the Axiom of Choice, which I didn't get.     I went to Wikipedia to see what the Axiom of Choice is, but as often happens with things like this, the Wikipedia entry is not in plain, simple, understandable language. Can someone give me a nice simple explanation of what this axiom is, and perhaps explain the XKCD joke as well? Is it possible for more than two particles to be entangled in a quantum way? So I know that two particles can be entangled in a quantum way, but is it possible that more than two particles be entangled in a quantum way? Most descriptions provide with two-particles cases, so I wonder. (It's hard to think of three particles entangled in spin, or so.)