THANKS ! Not sure how 'sa' got in the connection string for that 1 job.

".....on the Data Sources tab check the entire connection string for the connection manager...…"

• This reply was modified 4 years, 11 months ago by homebrew01.
• This reply was modified 4 years, 11 months ago by homebrew01.

Do you have execution plans before & after the slowdown that you can compare ?

Is the amount of data increasing ?

I doubt it's hardware related, but check the server event...

• This reply was modified 4 years, 11 months ago by homebrew01.
• This reply was modified 4 years, 11 months ago by homebrew01.

Thanks for following up with the solution.

It would be clearer if you specify 5 servers instead of server=xxxxxxx 5 times

server=Server1,...

Your 5 select examples look the same to me, so you will get the same result 5 times. Is that intended ?

Or table1 exists on 5 different servers and you...

• This reply was modified 5 years ago by homebrew01.

MySQL is different from MS SQL.

What are your goals ? Look for courses that lead towards a specific goal(s).

Maybe just increase the length of a variable ?

'X:\Backups\SERVER001\Database0001\Log\SERVER001$SERVER001
_Database001_Log_20200731_203617.trn'

Is not unusually long. Maybe there's a different problem ?

• This reply was modified 5 years, 1 month ago by homebrew01.

Thanks. Now the REAL problem is weeding through all the data. I captured production events for 30 minutes, and got 1 million records.

Then I decided to capture some data changes...

They may want a BAT file or something to call the stored procedure.

Is there a GUI method to browse, filter the EE_20200729.XEL  file I created yesterday ?

I am trying to find some stored procedure calls, triggers and table updates, invoked by a...

• This reply was modified 5 years, 1 month ago by homebrew01.
• This reply was modified 5 years, 1 month ago by homebrew01.

What app would you use to present the SP to the user so they can run it ?

It looks like SSMS Live Data option only works if the session is started or paused ? I did "Stop Session" and want to filer and narrow down data. I...

• This reply was modified 5 years, 1 month ago by homebrew01.
• This reply was modified 5 years, 1 month ago by homebrew01.

Where would I find this ?

"...How often is the OS swapping to its page file?..."

Could you set up a local Maint Plan to take Trans Log backup during the maintenance window ?

You can look at the trans log backup file location, and see the sizes of the .TRN files.

I usually backup every 15 minutes.

Your 6:00 and 9:00 backups took 43 seconds,...