Tag Info

New answers tagged

0

Use the maxmemory to set a limit to how much your Redis database can grow too. Failing to do so, Redis will grow until the OS will kill it once memory is exhausted (per your current experience). The usage of maxmemory should be coupled with maxmemory-policy - you can choose from different eviction policies depending on your use case's requirements. For ...


3

Hopefully you now realise this is not a problem with SQL Server but a problem with the volume of data you have in your database and the small amount of memory on the server: Recommendations: 8GB is a really small amount of memory for even a Standard Edition server. I have 20GB in my laptop!? Consider upgrading to 64GB. If not, why not? It wouldn't be ...


1

I agree with every fact that Sean mentioned. The simple answer is this is not an issue UNLESS you show me out of memory condition. This is how SQL Server behaves. Like I mentioned in thread you took reference SQL Server memory management is dynamic. If you see more pages for particular database then its being used frequently by queries or other wise it will ...


3

Honestly, you're basically saying "my application is using all of this data, how do I make it stop doing that?". Tell your end users or application to stop. Not going to go over well? Didn't think so. There is an algorithm that is used to keep pages in cache, obviously these pages are used more often and aged out less. If you want to keep other pages in ...


0

I suggest that use partitioning for your table in first. and then use page data compression for all of index on all partition except last partition. also recommendation you that set read only option of partitioned file group to true(except last file group). also you need to survey your queries in order to optimize them.


-2

CREATE TEMPORARY TABLE IF NOT EXISTS temp (Months VARCHAR(50),Sequence INT) AS ( SELECT CONCAT(MONTHNAME(m1),' ',YEAR(m1)) AS Months,CONVERT(m1,DATE) AS Sequence FROM ( SELECT ('2014-01-01' - INTERVAL DAYOFMONTH('2014-01-01')-1 DAY) +INTERVAL m MONTH AS m1 FROM ( SELECT @rownum:=@rownum+1 AS m FROM (SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4) ...


1

Found the answer: http://blogs.msdn.com/b/sql_shep/archive/2012/06/21/sql-server-2012-license-core-limitaion.aspx My consultants installed the wrong version (CAL instead of core), so it's limited to 20 cores.


0

I would try to answer the questions point wise After few days if i check in task manager, it shows the load of 31 GB Memory but actually maximum is alloted to SQL is 28 GB and nothing is running on he server First please note that task manager is not correct place to look for SQL Server memory utilization especially when SQL Server service account has ...


1

There is not much to check if you have found out that SQL Server requires more memory.Is your OS on physical machine or Virtual if it is virtual adding memory would be easy. You must know that SQL Server 2012 standrd edition supports maximum of 64G memory. After adding new memory you must change max server memory setting using sp_configure. Set max server ...


2

Although you limited the memory to 28 GB out of 32 GB, this is not the only memory that SQL Server uses. The running programs and needs within Windows take some additional space. If you want to closely tune the memory use, I recommend reading this, which works well for my servers. See Jonathan Kehayias at: ...


0

You could try my solution to this issue - MySQLDumpSplitter. It takes a dump file and splits it into individual tables, which you may find convenient. My email is there should it not conform to your needs - I could take a look at any issues you may have in an effort to make the tool better. Disclaimer: I wrote it, and as you'll see from the Readme, it works ...


1

Is there any trace flag enabled or any tweaking into startup parameters of SQL server can you please check that.Have a look at below Microsoft support article http://support.microsoft.com/kb/2199576/en-us Keep max lock value to default EXEC sp_configure 'locks', 0 ( I guess you tried this option already) Now if you face this issue again best possible ...


1

In Oracle (and other RDBMSs), when an SQL statement is run for the first time, it is cached and if somebody else wants to run a similar statement, the plan is taken from the cache - or shared pool. This is called soft parsing and is less costly than going to the trouble of redoing it entirely. So, the term "construct" in this context means an in memory ...


0

pagefile.sys % Usage shows total system committed not what currently is utilized. This value can increase due to load when system finds out it has to back process with more page file. Have a look at below link for detailed explanation http://blogs.technet.com/b/perfguru/archive/2008/01/08/explanation-of-pagefile-usage-as-reported-in-the-task-manager.aspx I ...


0

You have a complex environment with SSIS and SSAS so you have to be cautious with max server memory setting for SQL Server in your scenario Jonathans blogs would not provide complete help. You should refer to below Microsoft link for determining memory requirement for SSIS http://technet.microsoft.com/library/Cc966529#EEAA You should leave enough memory for ...


1

The page faults metric for MongoDB on Windows essentially contains hard (actually hitting disk) and soft (reallocating a pointer in memory) page faults. If you run the same experiment on Linux, the page fault metric only reports hard page faults and you will see the behavior you expect. This is a known issue with the Windows version and the relevant issue ...


1

You should always set your max memory away from default and leave some room for OS (see Jonathan's post of how much Memory to leave based on the amount of RAM installed). Jonathan Kehayias has blogged about : How much memory does my SQL Server actually need? reserve 1 GB of RAM for the OS, 1 GB for each 4 GB of RAM installed from 4–16 GB, and then 1 GB ...



Top 50 recent answers are included