Linked Questions
46 questions linked to/from MAXDOP setting algorithm for SQL Server
-3
votes
1
answer
879
views
Script to setup MAXDOP [duplicate]
I need to script toi set MAXDOP.
----I have this script----
select cpu_count,
case
when cpu_count/hyperthread_ratio >8 then 8
else cpu_count/hyperthread_ratio
end as optimal_maxdop_setting
from ...
- 11
0
votes
1
answer
124
views
MAXDOP Setting on a SQL Server [duplicate]
When upgrading and creating my new SQL server farm on 2016 I researched things to set on the server, one being MAXDOP setting.
From reading up about the setting I have set it at 8 on a server that has ...
- 73
2
votes
1
answer
295
views
Max Degree of Parallelism for SQL Server 2008 [duplicate]
Microsoft have recommendations around setting MAXDOP on various versions of SQL Server, but this (old) article raises some issues and recommends setting MAXDOP = 1 generally for SQL Server 2005 and ...
- 41
0
votes
1
answer
279
views
What is the MAXDOP value for the server which doesn't have NUMA [duplicate]
Im using a SQL Server with the below configurations.
4 Core.
8 Logical processors.
No NUMA.
NO hyperthreading.
I read this Doc:
Recommendations and guidelines for the "max degree of parallelism" ...
- 1,840
0
votes
0
answers
65
views
SQL Server MAXDOP , microsoft reommendation [duplicate]
Microsoft's recommendation for setting MAXDOP is based on logical processors count.
https://support.microsoft.com/en-gb/kb/2806535
On my server which has one hex core CPU, hyper threaded,6 physical ...
- 689
0
votes
0
answers
29
views
Need to know how to check how much time job takes to complete execution [duplicate]
How we can determine how much time a job takes to execute in sql server, I have a job which runs every hour, I also having some performance issue so I wanted to check if the performance issue is ...
- 217
35
votes
4
answers
26k
views
CPU clock speed versus CPU core count - higher GHz, or more cores for SQL Server?
We are beginning to provision a set of physical servers for a virtual cluster of SQL Server 2016 nodes within VMware. We will be utilizing Enterprise Edition licenses.
We plan on setting up 6 nodes, ...
- 1,544
25
votes
2
answers
34k
views
Need to understand parallel query execution error
Today we experienced a degradation in performance on our production sql server. Durring the time this occurred we logged several "The query processor could not start the necessary thread resources ...
- 2,097
23
votes
1
answer
54k
views
Upgrade SQL Server 2000 database to 2008 R2 and enable new features
I have recently upgraded SQL Server 2000 database to 2008 R2.
What I did was:
Shutdown SQL Server 2000 (express) service on old machine,
Move datafiles (mydatabase.mdf and mydatabase.ldf) to new ...
- 345
15
votes
4
answers
28k
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 ...
- 151
24
votes
3
answers
1k
views
Does CPU utilization affect the cost of foreign NUMA access?
Scenario
Let's assume I have a SQL Server with 4 sockets with each 1 NUMA node. Each socket has 4 physical cores. There is 512 GB of memory total so each NUMA node has 128 GB of RAM.
A key table is ...
- 407
9
votes
1
answer
67k
views
Insert into table select * from table vs bulk insert
I just wanted to know that SQL Statement INSERT INTO TABLE1 SELECT * FROM TABLE2, will work same like bulk insert ?
If no, Is there any way exclude index while inserting records. Process is inserting ...
- 161
8
votes
4
answers
3k
views
MAXDOP Settings for SQL Server 2014
I know this question has been asked number of times and also has answers to it but, I still need a bit more guidance on this subject.
Below is the details of my CPU from SSMS:
Below is CPU tab from ...
- 3,794
5
votes
2
answers
10k
views
Migrate all databases from one SQL Server 2005 to another
We have a production SQL Server 2005 server on which we are hosting 200 databases.
We want to host these databases on our new server. On new server SQL Server 2005 is installed and is ready.
I want ...
- 177
5
votes
3
answers
14k
views
SQL Performance issue after migration from SQL Server 2005 to SQL Server 2012
Yesterday we migrated a SQL Server 2005 database to SQL Server 2012. We made a full backup and restored it on the new server.
Problem now is that the database on SQL Server 2012 is much slower than ...
- 181