| Author |
 Topic  |
|
|
JohnC
Junior Member
215 Posts |
 Posted - 17 March 2008 : 08:10:14
|
| I'm starting to see intermittent slow page-loads with my (150MB DB) Snitz forums. My hosting company doesn't have much experience with SQL servers and can't offer any help except to move my DB to a new DB server in hopes someone isn't abusing it. I'm wondering if it would be beneficial to migrate from MS SQL 2005 Express to MS SQL 2005... thinking it might help with performance. Are there any SQL guru’s here that can perhaps shed some light on this? |
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 17 March 2008 : 08:15:41
|
the difference in performance is more likely to be defined by the server hardware that is running it rather than the differences between express and the full version since the differences are not to do with performance (apart from the one cpu limit)
My guess would be that the webserver is busy and therefore sql express is not getting enough resources so moving it to a dedicated server machine should (depending on network traffic) offer some improvement |
 |
|
|
JohnC
Junior Member
215 Posts |
Posted - 18 March 2008 : 08:20:23
|
| Thanks for your reply, HuwR! That's makes perfect sense. I guess I should start looking at semi-dedicated or dedicated hosting for my site. |
|
|
|
JohnC
Junior Member
215 Posts |
Posted - 21 March 2008 : 07:18:20
|
| Just out of curiosity though, how hard is it to migrate the SQL 2005 Express database to SQL 2005? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 21 March 2008 : 07:22:58
|
| It would take the same effort as importing the data from another SQL Server database - basically the same number of steps detailed in a migration for SQL Server - create database structure, import database data, while preserving primary key and foreign key values. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 21 March 2008 : 14:43:42
|
| Or you could probably just do a backup and restore to the new server - maybe try it out once before doing it in production, but I'm not aware of reasons why it ought to be a problem. |
|
|
|
mastersolutionsllc
Starting Member
6 Posts |
Posted - 24 March 2008 : 10:10:47
|
My understanding is express does have a serious performance limit. They intentionally slow it down after 5 connections or something like that. A web based forum could easily go voer that right away.
Also, the db should be identical. The SQL Express is simply stripped down. You should be able to migrate it without problems, unless I am seriously mistaken. I have done it a lot on development SQL dbs. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 24 March 2008 : 12:38:42
|
There is no connection limit in SQL Server Express Edition - you're thinking of the MSDE.
The only limitations in the Express Edition are that it is limited to 1 CPU (you can have more, but it will only use one core), 1GB addressable RAM, max database size of 4GB (If you've hit that you really need to upgrade anyway  ) |
Edited by - AnonJr on 24 March 2008 12:40:11 |
|
|
| |
Topic |
|
Topic Locked
