Production Server and Test Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » Production Server and Test Server

Production Server and Test Server

Rate Topic

Display Mode

Topic Options

Author

Message

discover.sql

Posted Tuesday, May 05, 2009 6:35 AM

SSC 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

Jack Corbett

Posted Tuesday, May 05, 2009 7:51 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

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

discover.sql

Posted Tuesday, May 05, 2009 8:19 AM

SSC 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

Jack Corbett

Posted Tuesday, May 05, 2009 8:26 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

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.

Post #710267

discover.sql

Posted Tuesday, May 05, 2009 2:47 PM

SSC 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 »

Permissions