| Author |
Topic |
|
anaylor01
Starting Member
28 Posts |
 Posted - 2012-01-09 : 01:09:20
|
| My company wants to have 5 environments for our production. Prod, QA, Staging, Dev and Sandobx. Our databases are about 1 tb each. Is there anyway to share data files or something that will help to reduce space needed? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2012-01-09 : 13:16:15
|
| It you have a section of the Database that is large and doesn't change, you could make a single Database for that and link to it from the other Database using synonyms. Not nessessarily a good idea but it is an option.Another idea, and we are doing this, if you have a lot of audit type data, you could purge it from the QA, Staging, Dev and Sandbox to save memory. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-01-10 : 01:48:52
|
| If you want to maintain Prod,QA,staging,dev, sandbox - one option you have for the non-Prod environments is to maintain smaller datasets . You could also consider table partitioning - allowing you to move data around in a more efficient wayJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2012-01-10 : 09:01:16
|
quote:
...You could also consider table partitioning - allowing you to move data around in a more efficient way
I thought table partitioning reduces time not space. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-01-12 : 01:38:01
|
| Another way of using Table Partitioning to decrease space , is to compress a partition .For example , a less active partition e could be compressed , where a more active part may be uncompressedJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2012-01-12 : 11:53:46
|
quote:
Originally posted by jackv
Another way of using Table Partitioning to decrease space , is to compress a partition .For example , a less active partition e could be compressed , where a more active part may be uncompressedJack Vamvas--------------------http://www.sqlserver-dba.com
Oh thanks, interesting.Would the compressed one be pretty slow for reads/ writes? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-01-12 : 12:51:09
|
| Our testing has shown that compression is speeding up things, by far. There's probably a write penalty occurring on our systems, but it's fast enough. We have a huge boost in performance for selects. The one big system that we have it on was approaching 10TB before we enabled compression, and it has a huge amount of inserts occurring throughout the day, but we are still okay with the writes.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2012-01-12 : 13:07:25
|
quote:
Originally posted by tkizer
Our testing has shown that compression is speeding up things, by far. There's probably a write penalty occurring on our systems, but it's fast enough. We have a huge boost in performance for selects. The one big system that we have it on was approaching 10TB before we enabled compression, and it has a huge amount of inserts occurring throughout the day, but we are still okay with the writes.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Interesting.Performance boost? Surprising. Would this be because bringing from disk to buffer pool would be faster since there would be less volume when compressed? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
Muliple environments