question

jchatton1 avatar image
jchatton1 asked

SQL Server 2012 Environments Setup Best Practice

We are a small consulting shop, with about 12 end users for SSAS and SSRS. We at the point we need a separate DEV environment. So is it better to create another instance for the DEV environment, or because of low use, is making simply a DEV copy of the database within our 1 environment acceptable?
best-practicedevelopment2012design
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks for the help Grant and Blackhawk
0 Likes 0 ·
In order for this site to work, you need to help us out. Please indicate all helpful answers by clicking on the thumbs up next to them. If any one answer lead to a solution, indicate that by clicking on the check mark next to that answer.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
Since it's Dev and serious issues could occur, I would prefer to isolate it from production. It doesn't need to be on a larger server, but you're better off having it separate. As to low use, in theory, it should get quite a bit of use, just not 24/7 like a production machine.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Blackhawk-17 avatar image
Blackhawk-17 answered
I highly suggest a new instance. Someone, at some point, **will** make a mistake and run the DEV updates/deletes on PROD if the dBs are side by side.
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks for the guidance. You bring up a good point and question, another instance on the same server? Put it on a virtual?
0 Likes 0 ·
As per Grant's isolation suggestion - throw it on a virtual. You've lessened the chances of mistakes, you won't be impacting resources for PROD and by running on a lesser system you'll see performance issues far earlier.
0 Likes 0 ·
And by separating to another system you can also change the security so that people aren't accidently dropping tables in production.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.