Tag Info

New answers tagged

-1

Identify the Cache memory required for each database in your server and set Max. Server Memory higher than its cumulative value(not necessary to configure the value greater than twice of cumulative cache memory). By doing this, you can allocate the memory needed for MSSQL server and free up the RAM unnecessarily occupied by the buffer cache. Note: Max. ...


0

SQL server will use as much memory as possible. You can and you should allocate limited memory in the SQL server settings (properties) to leave enough for OS and IIS. How much memory foe each depends on what each does, load and expectations. This article explains this in depth: ...


3

Question: Considering scenario, that we have 8GB and we also have IIS hosted in this server (which I believe is a bad idea), in how much RAM should SQL Server use? The answer to how much memory SQL Server would use is as much as it can. For that reason its always advisable to put appropriate value for max server memory. Please dont use task manager to ...


0

The answer is It Depends on exactly how much load your are putting on SQL Server, IIS, and so forth. (SSIS? SSRS?) All of these things add up. Jonathan Keheyias has a general formula that works pretty good for me: "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 for every 8 GB RAM installed above 16 GB ...


1

Which version are you using? 5.6.? I did however came across this bug, hopefully it helps. http://bugs.mysql.com/bug.php?id=68287


0

Based on my own research, google results and ansible's answer, I was able to come up with complete solution for Oracle Linux 7. Everytime you read Kitet - this is my Oracle Instance SID. To start or stop database, dbstart and dbshut scripts are used respectively. They are located in $ORACLE_HOME/bin. Both of them need a parameter, which is $ORACLE_HOME. If ...


0

First, are you using the $ORACLE_HOME/bin/oraenv command? This is what typically sets the ORACLE_BASE, ORACLE_HOME, and ORACLE_SID environment variables on a Linux system using the Oracle Database. When connecting to an Oracle database from the command line in Linux, running oraenv should usually be your first step, as it will prompt you for the SID of the ...


0

I will update my progress and other stuff I discovered below. Checking /etc/init.d/mysql mySQL starts with this su - mysql -s /bin/sh -c "/usr/bin/mysqld_safe > /dev/null 2>&1 &" The error log showed that 65535 open_files_limit directive was not successful. Simply, mysql user could not set its own limits. Raising ulimit nofiles for all ...


0

Look at http://stackoverflow.com/questions/11442191/parallelizing-a-numpy-vector-operation Essentially, you could do this in numpy relatively easily, with numexpr to take advantage of multi core. I haven't tried it yet, so YMMV.


2

You should put everything on a level playing field. How ? Without proper tuning, it is possible for older versions of MySQL to outrun and outgun new versions. Sep 25, 2013 : Why should I use InnoDB and MySql instead of XtraDB and MariaDB? Mar 26, 2012 : Percona vs MySQL Nov 24, 2011 : Why mysql 5.5 slower than 5.1 (linux,using mysqlslap) Oct 05, 2011 : ...



Top 50 recent answers are included