I want to configure SQL Server so that any commands coming from a specific host get processed separately. My goal is to be able to test the impact of rather drastic changes without having to make a copy of a gigantic database. Ideally,
I would also be able to tell how much of a resource impact this was causing on the server.
When I finish, I am perfectly happy to throw it all away and repeat the parts I wanted 'for real' as a test for the push to the staging / production servers. I guess it would be like transactions but across connections
and applications... a big, cumulative transaction per-connecting-machine. I believe snapshots offer similar functionality but as far as I know they are read-only.
Thanks; I hope this is the right place to ask whether or not this type of feature exists in SQL Server.
View Complete Post