RBS in SQL Server 2008 R2

• pshaship

  SSCertifiable

  Points: 6125

  More actions

  July 26, 2011 at 11:22 pm

  #240586

  Hi,

  Could you please provide me the Microsoft link or guide lines to install and configure RBS in SQL Server 2008 R2?

  Thanks

• Johan Bijnens

  SSC Guru

  Points: 135369

  More actions

  July 27, 2011 at 1:36 am

  #1358989

  Are you refering the Oracle rollback segments ?

  In sqlserver that information is stored in the database log file(s).

  Pre-size it as much as you can, but if you chose to let it auto grow, let it grow in a reasonable amount of MB ( not in percentages please !) The goal of this is to avoid having to much Virtual Log Files (internal active segments of the log file)

  ( more info:

  -http://www.simple-talk.com/sql/database-administration/monitoring-sql-server-virtual-log-file-fragmentation/?utm_source=simpletalk&utm_medium=email&utm_content=FileFragmentation20100111&utm_campaign=SQL

  -http://www.sqlskills.com/BLOGS/KIMBERLY/post/8-Steps-to-better-Transaction-Log-throughput.aspx

  )

  If you database is in simple recovery model, your log file size should at least be the size of your longest transaction.

  If your db is in bulk or full recovery, you should setup log backups to keep its size from growing on an on.

  Have a look at Managing Transaction Logs[/url]

  and Why is my transaction log full?[/url]

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me