and your questions is ... ?

"Thanks! So you won't recommended this and there could be problems it depends?"

In order to say more precisely, in your case I would "profile" each monitoring tool to get understanding ...

As usual - it depends. For instance, it depends on the way tools work and gather the data.

Some tools run server-side traces,  others collect data from DMVs.

I saw an in-house...

What do you use to "import data from one database to another" in the package?

Is "Table Lock"  setting in Oledb connection enabled?

it depends on lock granularity

in worst case scenario whole both tables will be locked for other sessions  till the end of tran

https://www.mssqltips.com/sqlservertutorial/3305/what-does-begin-tran-rollback-tran-and-commit-tran-mean/

you can use a simple check like the following:

use [msdb]
go
if db_name()!='master' return 
select getdate()
go

you will not see current date (select getdate()) because the current db is not...

in your case I would do the following:

1. Ensure that SQL server has enough memory now (check PLE's trend,  ring buffer for memory warnings). SQL Server as a process acquires...

I doubt BAG will allow you to take db offline for moving files.

That's why there is Step 1 in the list.

"when do I actually change the drive letters?"

It's Step 2...

Simplest way is the following:

1. remove a db from BAG
2. alter database and set proper location of files
3. take database offline and move files accordingly
4. take database online and verify...

Thanks for ignoring my hint about English. I will follow the same path next time.

Regarding the column names:   there's no quick and easy way to get both data & header in...

• This reply was modified 5 years, 4 months ago by  Andrey. Reason: added version for SQL2017- with XML PATH('')

imho, there are two options here:

1. your permissions script doesn't show current permissions correctly.

   -- check is there a personal login/username in user DB
   select * from sys.database_principals where...

"I hope the picture is clear and that somebody can help me." 

not quite so far

"When a new record, automatically, is created in the file then I want to...

• This reply was modified 5 years, 4 months ago by  Andrey. Reason: formatting

Try to restore recent backup of master db into another db  to check that it's not corrupted.

Jeff, I agree that on busy systems these 5 files (20 MB each) of default trace will be overwritten soon, but look at at from the following angle:

• it's available...