How to control the excessive use of ram by SQL Server?
Let’s learn how to control the excessive use of ram by SQL Server. The most accurate or helpful solution is served by Database Administrators.
There are ten answers to this question.
Best solution
The database server that I am using is running 6 different SQL Server instances. It has 48 GB RAM. And one of them is consuming more than 10 GB of RAM, total consumption is 20 GB for now. The RAM consumption is growing continuously. Couple of days before it was using more than 40 GB of RAM and the server was responding very slow. The application shows the crashing problems when saving data. So I restarted the SQL Server services. As soon as the services were restarted, the usage came down to ...
Answer:
That is by design. SQL Server is supposed to use all the available memory, as it is storing more and...
Shreejan sharma at Database Administrators Mark as irrelevant Undo
Other solutions
i have made a database in sql server 2005. In my web application i am using this database. i am also using a login server control. to use this control i need to add my sql server database which has a table for valid usernames and passwords into the App...
Answer:
You don't need a special table. you take the user's input username and password and use that to make...
somebody at Yahoo! Answers Mark as irrelevant Undo
Hello everyone, I've been tasked with taking care of the IT side of a new company that we're starting. The company is a records storage company, which means that we store boxes with documents, and keep the metadata and possibly scanned copies in...
Answer:
I would recommend keeping the SQL separate from your DHCP but you can accomplish this on one machine...
Karen Marshall at Quora Mark as irrelevant Undo
Thanks for your answer. The question refers to using git (the versioning system) to version control and collaborate on SQL development. Since SQL files don't have an effect until they are compiled as DB objects, it's not straightforward to me as to how...
Answer:
You need to think beyond version controlling individual files to how you are going to version control...
Bill Dennis at Quora Mark as irrelevant Undo
I'm planning on bying a new server with 8 gb of ram but want to use sql express 2012, if that a waste? or sql express will allow it? Thanks
Answer:
examine the license for SQL Server first. I don't think microsoft will allow that. from what I read...
muajaja at Yahoo! Answers Mark as irrelevant Undo
Hello, recently I got a Linux VPS to host a minecraft server. I now have to choose between what distro to use. The distros I am allowed to use are following: CentOS 5 with Parallels Plesk Panel 10 (64-bit) CentOS 5 with Parallels SB Panel 10 (64-bit...
Answer:
The overhead of running gnome and vnc outweigh the learning curve of bash. Considering you just have...
Enes at Yahoo! Answers Mark as irrelevant Undo
I'm interested in turning my rarely-used powerpc mac mini into a web/file server. Where are the good guides and resources for doing this? I have a 1.5 GHz Power PC G4 mac mini, with 10.4.10, 512 MB RAM, which I would like to turn into a web and file...
Answer:
I'm doing exactly what you are. Here's how: 1. Format and reinstall your mini from scratch. You don...
that girl at Ask.Metafilter.Com Mark as irrelevant Undo
I have a sql query that I use for search: $searchQuery = "John"; // example input $getinfo = mysql_query(" SELECT `nickname`, `description`, `moreinfo` FROM `users` WHERE `nickname` LIKE %$searchQuery% UNION SELECT `nickname`, `description...
Answer:
You can combine this into 1 SELECT by using OR in your WHERE clause: SELECT `nickname`, `description...
Ratchetr at Yahoo! Answers Mark as irrelevant Undo
I am investigating to see if it is possible to use a Windows Server hosting service to run my DAW (Digital Audio Workstation) remotely/over the internet via a tablet or netbook (possibly using the Open Sound Control (OSC) protocol) but I am a complete...
Answer:
You can probably get away with it. You'll need a way to stream display, mouse and keyboard data (using...
Rafael Vega at Quora Mark as irrelevant Undo
I want to create a dashboard that has following specifications: 1) Allow end-user to add/remove multiple motion charts onto the dashboard as needed. (*End-user doesn't have any programming knowledge or expertise in Tableau, QlikView, etc., so this is...
Answer:
Well I know alot of people use Highcharts.com for graphs, I'm not in love with it but it's decent compared...
Allan Branch at Quora Mark as irrelevant Undo
Related Q & A:
- How to connect Sql Server Database from android app?Best solution by Stack Overflow
- How to upgrade sql server express 2005 to 2008R2?Best solution by Server Fault
- Does it ever make sense to use RAM Disk to force RAM allocation for tempdb with SQL Server 2008?Best solution by Database Administrators
- How to output the results of an procedure in SQL server?Best solution by Stack Overflow
- How to make a computer use more RAM?Best solution by Super User
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.