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

How to control the excessive use of ram by SQL Server?

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...

Read more

Shreejan sharma at Database Administrators Mark as irrelevant Undo

Other solutions

Use of login server control in asp.net with sql server 2005?

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...

Read more

somebody at Yahoo! Answers Mark as irrelevant Undo

What kind of server should I buy for a new company?

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...

Read more

Karen Marshall at Quora Mark as irrelevant Undo

What is the usual methodology for using Git when developing in SQL Server (stored procedures, triggers, etc.)?

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...

Read more

Bill Dennis at Quora Mark as irrelevant Undo

Can someone tell me what are the hardware limitations of sql express 2012?

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...

Read more

muajaja at Yahoo! Answers Mark as irrelevant Undo

Minecra Server, What OS?

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...

Read more

Enes at Yahoo! Answers Mark as irrelevant Undo

Help me turn my mac mini into a home web and file server

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...

Read more

that girl at Ask.Metafilter.Com Mark as irrelevant Undo

SQL: search UNION question?

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...

Read more

Ratchetr at Yahoo! Answers Mark as irrelevant Undo

Can a Windows Server host any program designed for Windows OS?

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...

Read more

Rafael Vega at Quora Mark as irrelevant Undo

Dashboard with multiple synchronized customizable motion charts - what platform/software should I use?

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...

Read more

Allan Branch at Quora Mark as irrelevant Undo

Just Added Q & A:

Find solution

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.