Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Production Server and Test Server Expand / Collapse
Author
Message
Posted Tuesday, May 5, 2009 6:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 15, 2013 9:08 AM
Points: 30, Visits: 173
Hi,

We currently have seperate servers for our production and test database.
I would like to know if there would be any problems if we start having them on the same server?

Thanks
Shruti
Post #710106
Posted Tuesday, May 5, 2009 7:51 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:18 AM
Points: 10,340, Visits: 13,342
Well, you could do it, but typically you want to be able to try out new queries on test databases and you may have a poorly written query or a bug that consumes resources which will cause problems in your production databases if they are on the same server. Also you should be testing service packs and CU's on your test server before applying to production.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #710213
Posted Tuesday, May 5, 2009 8:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 15, 2013 9:08 AM
Points: 30, Visits: 173
Hi Could you please elaborate on CU's and service packs?
Thanks
Shruti
Post #710255
Posted Tuesday, May 5, 2009 8:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:18 AM
Points: 10,340, Visits: 13,342
A CU is a cumulative update of fixes that is not as rigorously tested as a service pack. These fixes can change the behavior of code so that what worked no longer works or no longer works as expected, which is why when applying them you should do so to a test server first, then to a production server.

A service pack is an rigorously tested update to the software that fixes bugs and can include new features. Again the update(s) couls change behavior of code so needs to be tested before applying to a production server.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #710267
Posted Tuesday, May 5, 2009 2:47 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 15, 2013 9:08 AM
Points: 30, Visits: 173
Thanks Jack
Post #710659
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse