Hi VastSQL,

Can you share your experience migrating AG databases? Finally, what steps do you take?

Thank you,

Regards,

Jeff,

My largest table has 20 million records and uses around 20 gigs but my tempdb maximum size is 192 gigs.

Regards,

Thanks for your responses,

We have more sorts and joins.

Thank you

Hi Friends,

Thanks for your answers,

A question may be simple for  you:

Can I play with different sizes for my Tempdb files while not trespassing the limits? Do I have to request...

Hi Mr. Brian,

Thank you very much for your ideas

I have found my auditing records redirected to files per day.

The problem will be querying those files for users in charge of...

Hi Gentlemen,

Awesome answers and more interesting video.

Thanks both for your guidance and time in this the topic

I have good tools to attend my request

Thank you very much

Hi sqlguru,

It looks not so easy to determine exactly what happened or what user is involved, I think you will need to implement a SQL Server Audit to fulfill your...

ScottPletcher,

Thanks a lot, I am thinking how to alert my boss that we need to make an investment on this.

Thanks again

Phil,

The caller is the same for another packages that are running ok, in the connection string it has a username and password with sysadmin privileges to connect to the database, ...

I'm attaching 2 screenshots,

Atach #1, partial invoking command

Atach #2, Error message from SSIS Dashboard

Thanks

AlphaTangoWhiskey,

Yes, when I execute from the catalog is as you describe.

I open the ssms console using the account related to the Job and execute succesfully the same store procedure.

I run...

Hi,

This is my invokation,

exec [dbo].[sp_MydearSP]  Variable_1

WITH RESULT SETS

(

(

Par1 varchar(max) null,

Par2 varchar(max) null,

Par3 varchar(max) null

)

)

I'm using SQL Server 2016 developer edition, in the testing server we have SQL Server 2019 Developer...

UPDATE: Still no working from Workstations, I have made the following checks:

I have discarded network ip related problems and now I am focused in the authentication problem.

I have restored the...

• This reply was modified 3 years, 9 months ago by  Lou.
• This reply was modified 3 years, 9 months ago by  Lou.

Garryha,

That's the life in a day for a dba.

There are many factors that could be behind that cpu presure scenario.

SQL Server Performance Dashboard  could give you a quickly view of...

Sqltester1,

Availability groups support 8 secondary-replicas and all nodes running as asychronous mode or up to 3 replicas can run in syncronous mode.

But it depends on what you want to achieve.

Best...

• This reply was modified 3 years, 10 months ago by  Lou.