New answers tagged

1

sp_helpdevice does list all allocated fragments on a device when you specify the device name. This includes the size of each fragment, but indeed not the free/used metrics. Those would not be difficult to write yourself however.


0

thanks for your answer. Ok, I did vmstat thing that's suggested in Oracle's site. Got this, I really don't know if there's something abnormal with these statistics. procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu----- r b swpd free buff cache si so bi bo in cs us sy id wa st 0 0 39 280 43 ...


1

Yes, you are right. Memory is used by dormant databases I mentioned this in the following posts over the years Nov 13, 2015 : #1041 - Out of memory issue in mysql Apr 22, 2014 : Do Inactive MySQL Databases Consume Memory? Apr 21, 2014 : Adding new tables -- memory usage increases Lots of tables ? Lots of columns ? Of course, that is less memory for ...


5

The reason that the size_in_bytes field of the sys.dm_exec_cached_plans DMV, at least in terms of "Compiled Plans", is larger than the CachedPlanSize attribute of the QueryPlan node in the XML plan is because a Compiled Plan is not the same thing as a Query Plan. A Compiled Plan is comprised of multiple Memory Objects, the combined size of which equates to ...


2

This is not an complete answer, will add more to the answer as I get further information from you. The output of errorlog had dbcc memorystatus dump and what was noticed was Process/System Counts Value(in Bytes) ---------------------------------------- ---------- Available Physical Memory 1217605632---1.1 G Available ...


3

I think I might have a legit answer .. and its a bug. (similar was found when running checkdb in 2014 & fixed in SP1 + CU1) When I run the query as is, SQL Server crashes 2016-06-16 17:27:32.00 spid37s Failed allocate pages: FAIL_PAGE_ALLOCATION 1 And in the error log I see : MEMORYCLERK_SQLQUERYEXEC (node 0) KB -------------...


2

I want to load my entire database into memory, but how can I do this? Before figuring out "how" to do something, it is often best to be clear on "why" that something should be done. So, why exactly do you want to load your entire database into memory? Memory is a finite resource, so it needs to be used efficiently / wisely. I have about 256 GB memory ...


0

You can start by creating the database without using AUTOCONFIGURE. Once it is created use AUTOCONFIGURE with the option APPLY NONE. It will show you what DB2 thinks are better settings. Many DBAs then use the output of APPLY NONE as input to manually setting the values using update db cfg, it is a common approach.


1

Amit, the problem is that this variable is set to reload a copy of the buffer pool dumped to disk during a stop/restart process. In order to achieve this you need to set innodb_buffer_pool_dump_at_shutdown to ON prior to restart your server, please check this link for further info: https://dev.mysql.com/doc/refman/5.6/en/innodb-preload-buffer-pool.html ...


1

To contribute a little more to this, there is a post on dba.stackexchange.com that explains this situation a little more: SQL Server Max Memory not limiting use of RAM. Also, in the answers on that question, Mark Storey-Smith recommends reading Brent Ozar's article "A Sysadmin's Guide to Microsoft SQL Server Memory" to further one's understanding on how ...



Top 50 recent answers are included