We have a SharePoint 2010 farm with 2 web front-end servers and 1 sql server database. The database server this farm uses is typical single instance sql server where all the databases, including content database, are stored.
The sql server instance is set up with remote BLOB, so all binary files are chunk-saved into a disk on the sql server OS.
This is a production system we've set up a couple of years ago and currently the content database has surpassed 100gb.
This isn't a big emergency but I'm planning now to create a second instance of on the same sql server to attach another content database. I'd like to do another sql server instance because this way I can use another drive attached to the OS. This second data drive will give us more space as the first one is several months away from being full. I will create a database in that instance and follow the directions here, which is basically how to add a new content-database to the existing web application.
Do I have to configure remote BLOB again for a new SQL server instance? Whether it does or does not, is this a typical scenario / plan?