August 21, 2017 at 12:19 am
I have 16 Gb of memory in my box and I have 2 sql instances, How should I cap memory in these two like 6 GB each or can I allocate 12 GB to each instance.
Need some input.
August 21, 2017 at 12:33 am
No idea. How busy are each of them? How much data do they work with?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 21, 2017 at 7:01 am
premkuttan - Monday, August 21, 2017 12:19 AMI have 16 Gb of memory in my box and I have 2 sql instances, How should I cap memory in these two like 6 GB each or can I allocate 12 GB to each instance.
Need some input.
if i were you i will look at cache usage by each database, Top 20 commands and if majority are BCP/Bulk inserts or data modifications i will do the opposite way.
@JayMunnangi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply