Very Slow SQL Server Performance
Over the past several weeks, we have noticed that the performance from our shared SQL Server has been degrading. In the last week, it's dipped well below our acceptable threshold - we're seeing things like sorting a 4,000 record table take 20-30 seconds or more. Can you take a look and see if something is up with the server we're running on?
The application name is "mega-mvc" and the SQL server is a961aa55-07b9-4b8b-a9bc-9fff01452c9b.sqlserver.sequelizer.com.
Thanks!
Discussions are closed to public comments.
If you need help with AppHarbor please
start a new discussion.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
Support Staff 1 Posted by rune on Sep 01, 2014 @ 08:25 PM
Hi,
Do you maybe have an example of a query that takes longer to load? It's possible that it's related to changes in the underlying database (size, total number of records and whether indexes are applied correctly).
The issue could also be related to variable performance on the shared SQL server instance. If you're using the database for production purposes I'd recommend that you migrate to a dedicated option. We offer dedicated SQL server instances (and have a few new plans coming up soon with a better performance/price ratio if you're interested in those), or you can use for instance Amazon's RDS instances. They recently introduced the new T2 instance type which are very affordable, dedicated and offering CPU boosting capabilities.
Best,
Rune
2 Posted by mega on Sep 01, 2014 @ 09:01 PM
Here's a query that takes ~25 seconds to run on a table with less than 5k rows:
select * from orders where StoreId = 2 order by dateplaced
...though when I run it now, it seems mostly performant again.
I'd love to move up to a dedicated SQL Server, but going from $10/month to $200/month is a pretty big jump. Can you give me any hints at what the new pricing structure might be?
Support Staff 3 Posted by rune on Sep 02, 2014 @ 04:33 AM
Ok I see the performance issue you described - and it does appear to be related to load on the database server. The service has been restarted and performance is back to "normal", but it's important to note that the variable performance will likely become an issue again.
The new dedicated database plans will be faster, but the starting price will still be around $200/month. I can understand that this might be too much for your use, so I'd recommend checking out the T2 instances - they start around $16/month for SQL Server instances and should give you higher reliability (though lower peak performance) than your current database type.
Best,
Rune