Linked Questions

0
votes
1answer
209 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" ...
0
votes
0answers
51 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 ...
0
votes
0answers
24 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 ...
30
votes
4answers
14k 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, ...
23
votes
1answer
43k 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 ...
16
votes
2answers
24k 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 ...
15
votes
4answers
16k 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 ...
21
votes
3answers
939 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 ...
6
votes
2answers
47k 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 ...
8
votes
4answers
2k 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 ...
5
votes
2answers
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 ...
5
votes
3answers
13k 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 ...
4
votes
3answers
890 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 ...
2
votes
1answer
8k views

Some queries are very slow after index rebuild

After finding out almost all databases on my SQL Server had fragmentation over 40%, I decided to do an index rebuild on all tables using a fill factor of 80. After rebuilding all indexes, some ...
6
votes
2answers
10k views

SQL Server thread status

Our SQL is configured to use max of 704 threads,some times we get alerts stating only 10 threads are left,so i am not able to understand whether SQL keeps the thread open ,since again creating a new ...

15 30 50 per page