Linked Questions

0
votes
2answers
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 ...
1
vote
1answer
724 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 ...
3
votes
1answer
235 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 ...
0
votes
0answers
70 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 ...
2
votes
0answers
55 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 ...
-1
votes
1answer
52 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) ...
88
votes
6answers
80k 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 ...
5
votes
5answers
8k 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 ...
3
votes
2answers
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 ...
2
votes
2answers
1k 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 ...
2
votes
3answers
3k 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, ...
4
votes
2answers
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 ...
6
votes
1answer
495 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 ...
7
votes
2answers
563 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 ...
1
vote
0answers
2k views

SSRS 2008 report fast in test, slow in production: parameter sniffing problem?

We recently had an issue with reports running in an integrated SharePoint environment where the report runs fine in development, test and staging, but very slow (times out) in production. Running ...

15 30 50 per page