Linked Questions
25 questions linked to/from difference in execution plans on UAT and PROD server
1
vote
1
answer
1k
views
Queries not Running in Prod [duplicate]
I've an update statement which uses 2-3 tables. It runs in less than a second in QA but it takes forever in Prod. The number of records are exactly same and all the indexes are same too. In fact Prod ...
- 29
0
votes
2
answers
2k
views
Identical Servers but different query execution plans [duplicate]
We have two server with identical hardware configuration and SQL server configuration.
The only difference in the server's being:
Server SQL1 - 256 GB RAM
Server SQL2 - 128 GB RAM
The same database ...
- 342
3
votes
1
answer
278
views
Can low memory cause Table Spool operators in plan [duplicate]
I was trying to optimize a query and found that the plan had table spool(eager) in it. But when I ran it on another server which had much more memory(256GB compared to 64GB) than the other one the ...
- 1,738
0
votes
0
answers
73
views
TempDB causing high IO writes - dependent on server's max memory setting [duplicate]
I have a mirrored SQL Server 2012 database. The first server has a hugh tempdb write IO load when the maximum memory limit is set above 8192 mb.
These 8192 where the original setting for both the ...
- 101
-1
votes
1
answer
73
views
MS SQL Server unexplained differences in query speed [duplicate]
I have a production database and staging database, they contain the exact same data, the production database was backed up and restored as the staging database.
A particular operation (API call) ...
- 101
2
votes
0
answers
57
views
Queries running slower on production (failover cluster) than on homologation env [duplicate]
I have a Windows Server 2012 cluster with two nodes running SQL Server 2012 for production and a Windows 2012 single server with SQL Server 2012 for homologation. I just restored the production ...
- 355
94
votes
6
answers
93k
views
Why would SET ARITHABORT ON dramatically speed up a query?
The query is a single select containing a lot of grouping levels and aggragate operations.
With SET ARITHABORT ON is takes less than a second, otherwise it takes several minutes. We have seen this ...
- 3,582
5
votes
5
answers
9k
views
Steps after restoring to a different server
We have a 30 GB Database on SQL Server 2008 R2 Standard Edition. Yesterday we backed up the database and restored it to a different Virtual Machine which has exactly the same specs as the previous ...
user2211524
3
votes
2
answers
2k
views
New SQL Server with slow Index Spool (Eager Spool) and old server used index
So yesterday I posted this question regarding that we have upgraded from SQL Server 2008 to SQL Server 2017 and that we excperience some performance problems.
I got the answer to try updating ...
- 31
2
votes
3
answers
4k
views
Database is slow after server transfer
I have a big database, about 250GB, and recently our system had to be transfered to a new machine.
The old machine:
Has a Windows Server 2008 R2 Standard Edition
Runs SQL Server 2012
32GBs of RAM, ...
2
votes
2
answers
2k
views
Is it possible for increasing the SQL Server max memory limit to degrade performance?
As far as I can tell, raising the SQL Server max memory limit has no drawbacks, provided that sufficient memory is left for the OS and other applications.
Assuming this is the case, can there be any ...
- 459
7
votes
2
answers
1k
views
Increase Max Memory setting on a SQL Server Production
I have a production box with 5 instances on.
Version: SQL Server 2014 SP3 Enterprise.
I discovered that even though the machine has ~400GB memory assigned, the combined MAX MEMORY settings on all 5 ...
- 575
4
votes
2
answers
2k
views
SQL Server query on server taking longer than laptop
Our program uses an SQL server database as its back-end (SQL server 2008-r2 - 2014). The program is OK for performance but the Database seems to slow down a bit too much.
As part of the nightly ...
- 41
6
votes
1
answer
587
views
Performance problem after migration from SQL Server 2005 to 2012 [closed]
Last Friday, I migrated a SQL Server instance from 2005 Enterprise Edition to a brand new Windows Server 2012 server with SQL Server 2012 Enterprise Edition installed. Since then, users have started ...
0
votes
1
answer
2k
views
Why do two SQL Server instances give different plans for the same query
I executed the following locally in SSMS for each of two instances of SQL Server 2012 SP4-OD (11.0.7469.6) that live in separate Azure VMs and get very different execution plans:
SET STATISTICS IO, ...
- 2,181