Linked Questions

0
votes
1answer
474 views

Implenting Min Max memory configuration in Alwayson [duplicate]

I have never changed this setting for an AlwasyOn setup. What is the best practise to do this? Should I change the setting on the Secondary node first and then the primary? Please suggest . The ...
0
votes
0answers
58 views

Suggested Min/Max SQL Server memory [duplicate]

I've inherited multiple servers, each containing one database and one instance of SQL Server 2008 R2 SP2. Each server is set to use 12GB min/max memory and has Lock Pages in Memory enabled. The ...
15
votes
4answers
17k views

SQL Server max memory, page file, max degree parallelism

Three questions hope you DBA masters of the universe can answer: I know it is best practice to set SQL Server's max memory. So if a server with 44 GB RAM has SQL Server installed we should set the ...
9
votes
2answers
17k views

sql server max memory includes SSIS?

I have installed 2 instances of sql server plus SSIS on the following server. Note the amount of RAM is nearly 384 GB And this is the max and min memory settings that I have applied to my 2 ...
4
votes
2answers
19k views

Recommended memory configuration for many SQL Server instances per server

I am currently managing a server cluster for a SaaS system. We currently have 6 SQL servers running MSSQL 2008 R2. Each server is a quad core virtual machine with 16GB of RAM provisioned on a server ...
4
votes
3answers
941 views

Setting maxdop 1 vs setting the threshold for parallelism high

I am looking at a possible fringe case for parallelism settings. I've long since followed the credence that maxdop 1 is a viable option for Microsoft Dynamics CRM databases. As the nature of the ...
1
vote
1answer
958 views

Set Maximum Server Memory Higher Than What is Available to OS

I have a server that is being repurposed into a SQL Server. It came with more physical memory than the 32GB that can be seen by my OS (Windows Server 2008 R2). Management would like me to configure ...
-1
votes
4answers
998 views

What MAXDOP setting should be used for MS SQL Server 2012? [closed]

I am getting a performance degradation error in one of my cluster production server. The error is like that A significant part of sql server process memory has been paged out. This may result in ...
3
votes
1answer
469 views

Could 'Maximum Server Memory' be too low for large batched delete with captured output?

I'm trying to improve the performance of a SQL server database backup program that will create a new database to hold one years worth of report records, delete report records out of the main database, ...
4
votes
2answers
136 views

SQL server timeout after downgrade

After a downgrade from SQL 2008 R2 Enterprise to SQL 2008 R2 Standard. SQL Server after some time starts lagging and CPU use is around 95%-100% and I can't log in in "MS SQL server management studio", ...
1
vote
0answers
37 views

Beefing up capacity of existing AAG cluster

I am planning to add 3 new databases to an existing AAG cluster in a VM. The AAG has Veeam databases on it as of now. Veeam backups are not running on it as of now apart from a couple of batch ...