That part makes sense but what is still eluding me is that if I create the SSIS package from scratching using the OLE DB Driver then it still takes 20+...

I wanted to share a discovery I made regarding this subject. I used the import wizard to import a flat file into SQL using the Native Client and saved it...

My previous Google searches told me that the native client is deprecated and not recommended for use in new developments. I know that means it could function for many years...

I'm still having trouble following and maybe it's because I don't see how it will work for my situation. My setup is exactly like "Architectural Solution 2" in this article 

• This reply was modified 4 years, 2 months ago by  RonMexico.

The article you referenced is the one I followed to change the RegisterAllProvidersIP and HostRecordTTL settings. I'm a little confused what you mean by this part

Here, you have 1 name(listener) ...

• This reply was modified 4 years, 2 months ago by  RonMexico.

When I ping the DNS it will give a reply at first and then fail on the second attempt. I suspect that's because the first attempt returned the active IP...

That did the trick. I'll continue to monitor it to see if it gathers the data I'm looking for.

I've changed my focus to looking at XE. I was hoping capturing sql_batch_completed events would show how often the database is accessed. I set up my session to filter on...

I've worked with Audits in the past to capture different events so I'll start there.

My goal is to collect data to generate reports any time someone or something hits a...

I'll take a look at the resource governor as well. Thanks for the tip.

Previous communication to limit the number of connections hasn't worked. Some users run up to 20 at...

I'm assuming the script you are running prints the result to give you the update script which is why it is showing in the messages tab. Have you tried modifying...

It seems as though -force still looks to match and, if a match is found, then it drops and re-creates on the destination. It does not delete everything on the...

I looked into -force and, in my testing, found that it handles updates within a job so it is an acceptable solution for the update portion. I'm still hoping for...

Sounds like a small trade off in the grand scheme of things. Thanks for all the pointers.

That's a bunch of good information. Thanks for helping to clear that up, rvsc48.

Regarding scripts to keep logins, jobs, etc on the secondary up-to-date, doesn't that go against the idea...