".....BTW, are you getting minimally logged inserts into your target table(s)? If not that must be the first thing to make happen IMHO. Also, if you have indexes on the...

DDL attached.
SP code attached.
VIEW source code that is called from SP attached.
Skeleton is:

SELECT
305 COLUMNS
FROM
v_qv_Transformations --VIEW source code attaced
WHERE

Thom A.
My method works. I like it. If you don't understand it, that's fine.
It has nothing to do with the topic I am discussing.
Don't deviate from the...

The file is there.
But Script Task reports file does not exist.

If you use this method:
l_InputFolder = Dts.Variables("User::c_InputFolder").Value
You need to list all the variables in Script...

That's a puzzle.
When I Execute package from Informati0on Services Catalogs
I don't see any errors.
All steps SUCCESS / Green.

Script Task
checks if the file exists and...

You are right.

All biggest cntr_values are coming from PERF_COUNTER_BULK_COUNT cntr_type

cntr_type----------------cntr_type_definition
272696576--------------PERF_COUNTER_BULK_COUNT

so it's not useful at all to look at these values?
Even if you see...

That's what the plan was - to reduce stress on PRIMARY.
PRIMARY is server 51.
Users run reports against SECONDARY server 52 and server 57.
SECONDARY server 52 is not...

I figured it out.
Apparently we have two SECONDARY servers (things get more interesting...)
Let's call it server 52 and server 57

So it looks like we use AlwaysOn...

Question guys.

Why FIG 1 results (look above for query)
returns me duplicate sets of databases?
I see 2 records for each database_id.

If I get NULL
in secondary_recovery_health,
does it mean it's not healthy?

SELECT * FROM sys.availability_groups
--------------------------------------------------------------------------------------
0 rows

SELECT * FROM 

March 2, 2017 at 11:23 am

#1931291

No errors.
It's just when I query
sys.availability_groups
it returns records.

When I query sys.dm_hadr_availability_group_states
I get no records returned.
So I thought it's a permission thing.

Anybody knows how to check
how badly mirroring is behind?
Any scripts?