[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 75
  • Last Modified:

Is there a best practice for having separated an application and a SQL Database?

I am having a big problem, we have a COFIDI (A software for emitting invoices) application and the SQL database in the same server. The problem is that frequently,, the server stops due to memory saturation, and we have increased the amount of memory 3 times,, and every time the server takes all the memory. I know there is a best practice in the market for having separated these two components (application and SQL database). Can someone help me?
0
Apolo Victores
Asked:
Apolo Victores
  • 7
  • 4
  • 2
1 Solution
 
Scott PletcherSenior DBACommented:
Are you setting 'max memory' configuration in SQL Server to limit it so that it doesn't take all the RAM?
0
 
Apolo VictoresAuthor Commented:
Yes!, but It continues "eating"  all the memory,, and I need to separate the application and the SQL DB,, but I need to support it by this Best practice..
0
 
Scott PletcherSenior DBACommented:
So what help, specifically, do you need?
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
Apolo VictoresAuthor Commented:
I am so sorry Scott!, I do know I need to plan a better plan for the design and implementation, but currently I am taking the responsibility of this server/app , and as I think this current scheme is wrong ,I mean having the application and the Database in the same server, so in order to justify my asseveration I need to look into the best practices in the market.
Thanks!!
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
How much memory the server has?
Also, a part from application and SQL Server, what else is installed in the server?
0
 
Apolo VictoresAuthor Commented:
It has 16 GB, and there is just installed  the Application and the SQL  software (From Microsoft).
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Which versions and editions of WIndows Server and SQL Server are installed?
Are both 64bits?
0
 
Apolo VictoresAuthor Commented:
yes, both are 64 Bits
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
16GB isn't bad for a standard installation and use of SQL Server. How much it's configured as Max Server Memory?
Can you see any locks in the database? Do you know how much memory the application is consuming?
0
 
Apolo VictoresAuthor Commented:
I have seen that the application just consume 4 MB of Memory, but the SQLSRVR consumes the total memory,, and  I don´t know why,, also I would be so happy to restrict to the SQLSRVR  just to 12 GB of memory, in order to use the rest to trhe application.

Thanks!
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You change the maximum memory using the GUI. In SSMS right-click on the instance name and chose properties, then click the Memory node and under Server Memory Options enter the amount that you want for maximum server memory.

You can also do that with T-SQL. Just open a new query window in SSMS and paste the following code:
sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE
GO
sp_configure 'max server memory', 12288
GO
RECONFIGURE WITH OVERRIDE
GO
sp_configure 'show advanced options', 0;
GO
RECONFIGURE WITH OVERRIDE

Open in new window

0
 
Apolo VictoresAuthor Commented:
Thank you !, I will try and inform you!
0
 
Apolo VictoresAuthor Commented:
Thank you so much !  these instructions helped me a lot!
Now , I can see that the sqlsvr  process only takes these 12 GB of memory,, and also see that the application also consumes the 7 rest of the ramian memory.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 7
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now