All Questions
Tagged with upgrade performance
13 questions
1
vote
0
answers
65
views
Performance degradation after upgrading to MySQL 8
We have upgraded MySQL in our application from version 5.7.43 to version 8.0.35.
We are getting below exception while trying the fetch the records from the database.
231104 04:04:03 : com.mysql.jdbc....
- 11
2
votes
2
answers
164
views
Do MySQL/InnoDB stats tables persist through major version upgrades?
After performing a major version upgrade of a PostgreSQL database, the ANALYZE command needs to be run in order to repopulate tables for query statistics, which do not persist through the upgrade. ...
- 123
7
votes
2
answers
1k
views
Is the Query Store's Overall Resource Consumption report telling me my database is doing terribly or are the numbers just whacked?
Recently we upgraded one of our production servers from SQL Server 2016 to SQL Server 2019 (CU 15).
This was a great opportunity for me to enable Query Store on our main application database.
It's ...
- 39.5k
11
votes
4
answers
18k
views
SQL Server 2019 performance worse than 2012... am I missing something?
We have a SQL Server 2012 server which far outperforms a SQL Server 2019 database on (as far as I can see) the same infrastructure. We are hosting both databases on a cloud platform with the same SLAs....
- 1,621
5
votes
2
answers
2k
views
PostgreSQL extremely slow after upgrade from 9.3 to 9.4
We recently upgraded an Amazon RDS instance from PostgreSQL 9.3 to 9.4. There were no problems during the upgrade, and afterwards we ran VACUUM ANALYZE. Performance is now very slow across the board. ...
- 333
6
votes
1
answer
18k
views
Optimizing slow performance of simple SELECT query
I have an app called 'Links' where 1) users congregate in groups and add others, 2) post content for each other in the said groups. Groups are defined by a links_group table in my postgresql 9.6.5 DB, ...
- 2,039
0
votes
1
answer
108
views
Upgrading to SQL Server 2012 from SQL Server 2008 R2
I am planning to upgrade my SQL Server 2008 R2 Standard Edition to SQL Server 2012 Standard Edition.
I had been through many blogs on advantages of 2012 but I didn't find any performance comparison ...
- 908
4
votes
0
answers
339
views
Performance degradation after upgrade from 3.0.11 to 3.2.12
Environment: CentoOS 6 (kernel 2.6.32), MongoDB community edition 3.0.11 and 3.2.12 , storage engine MMAP, config servers on SCCC
We are experiencing performance degradation when moving from 3.0.11 ...
- 1,207
2
votes
2
answers
287
views
SQL Server - SQL Plan Management for baseline
I am a .Net developer. I have a database upgrade coming up (from SQL Server 2005 to SQL Server 2012). The database team will be handling the migration. But I have seen forums posts saying that after ...
- 900
5
votes
1
answer
17k
views
SQL Server performance is slow when migrated from SQL Server 2012 to SQL Server 2014 [duplicate]
We are trying to migrate from SQL Server 2012 to SQL Server 2014 on Windows 2012 R2 OS.
After the upgrade, we are doing performance testing and observed huge difference in running a simple query from ...
Gopi Srinivas Thutaram
7
votes
1
answer
4k
views
Slower queries after upgrade from mysql-5.5 to mysql-5.6
There is lots written about how MySql 5.6 is faster than MySql 5.5 (e.g. http://dev.mysql.com/tech-resources/articles/mysql-5.6.html) but we upgraded our Amazon RDS instance (using the new upgrade ...
- 241
1
vote
0
answers
563
views
Performance Hit when upgrading to Oracle 11gr2
I am experiencing the same symptoms as noted in this question which was closed and does not have a satisfactory answer.
Original Question
We've recently upgraded from Oracle 10gR2 (10.2.0.4 ) to ...
3
votes
1
answer
459
views
PostgreSQL memory spike upgrade from 8.2 to 9.1
We recently upgraded a few of our development computers from PostgreSQL 8.2 to 9.1, with plans on eventually upgrading our production servers. Everything seems well with the restore of the databases, ...
- 31