Tag Info

New answers tagged

1

Has anyone done an research as to the overhead created by enabling AWE on the 64-bit OS/SQL combination? This is one of the Myths that Paul Randal clearly debunks in his famous series - A SQL Server DBA myth a day On 64-bit systems (2005+): AWE is not required (and in fact enabling it does nothing). Also refer to Fun with Locked Pages, AWE, Task ...


0

The tool I needed to figure it out was RAMMAP, which showed the AWE pool as the memory hog. Yes, someone enabled AWE on a 64-bit OS with 64-bit SQL.


1

Why is SQL Server on the same box? "Perform Volume Maintenance Tasks" should certainly be granted to the service account used to run SQL Server since that will allow SQL Server to not spend time unnecessarily zero-ing files during expansion of existing files and creation of new files. "Lock Pages in Memory" would be a good consideration if you want to ...


6

(From the screenshot) I see an unusual configuration where you have SQL Server's Min and Max memory set the same. Leave min memory as default. See my answer to SQL Server Min Server Memory. To determine ideal memory, refer - How to determine ideal memory for instance? and SQL Server Maximum and Minimum memory configuration We have SSIS running packages on ...


3

How much memory does SSIS need? (The real answer is: It depends.) However, Jonathan Kehayias has a formula that is pretty good, or so I think, since it works great for me. https://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/ The simple formula for reserving space for needs other than SQL Server in Windows is: ...


1

Just a misunderstanding I guess. The unit for the given number is blocks (or buffers), not 1 kb like you assume. Quoting the manual for shared_buffers: Each buffer is 8192 bytes, unless a different value of BLCKSZ was chosen when building the server. Bold emphasis mine. SELECT pg_size_pretty(327680 * 8192::numeric); pg_size_pretty -------------- ...


1

DISCLAIMER : Not a Spider Storage Engine Expert I don't think the Query is totally the problem. It is not the Spider Storage Engine (SSE) as a whole. There is one particular aspect of the SSE that you should be concerned with: The DB Connection to each shard. Think about how a DB Connection allocates memory. Here are the buffers associated with a single ...


0

After thorough research, we determined that the problem was that WordPress was being attacked and it was causing MySQL to use the maximum amount of memory allotted to it in the configuration files. Even caching of WordPress pages could not stop this illegitimate traffic from using all of the memory because of the sheer volume of IP addresses the attackers ...


1

MySQL uses RAM in many ways... For caching data and indexes. In some sense, it does not matter how much RAM, since it is cache. This may be the biggest use, but it is a "shared" use. A complex SELECT may need a temporary table (eg, for GROUP BY and/or ORDER BY and/or subquery). This may be done in RAM, or it may not even attempt to do it in RAM, but ...


0

10 GB of ram -- nothing is threatening to hit this. open_files_limit=10000 -- Try 2000 query_cache_size=256M -- No more than 50M default-storage-engine=MyISAM -- Unless you already have some InnoDB tables, this means that innodb_buffer_pool_size may as well be 0 -- you aren't using it. So, I will guess one of this is the case: 32-bit OS 32-bit build of ...


1

I am not totally convinced MySQL is running out of memory. Here is why: ASPECT #1 When you use mysqltuner.pl, it calculates the total usage in the worst case scenario. It does it by adding 3 figures together key_buffer_size innodb_buffer_pool_size thread_memory : max_connections * the sum of sort_buffer_size join_buffer_size read_buffer_size ...


2

After a reboot of the server we noticed that the SQL service is only using half of the memory. SQL server will use memory as an when needed. Once you reboot your instance, it will take sql server some time to ramp up (bringing pages in the buffer pool), since a reboot will trash all the query plans and reset DMV data. Min server memory controls the ...



Top 50 recent answers are included