We ensured the master key and certificate is made available on secondary replica.

We haven't checked the progress on secondary node. But will monitor this time.

Below are some messages we are...

According to your table structure, there is no index on [MULE_BATCH_ID].  This means that SQL has to do a table scan to find the record.

You are doing...

According to your table structure, there is no index on [MULE_BATCH_ID].  This means that SQL has to do a table scan to find the record.

You are doing a select...

Hi Jeffrey,

Thanks for sharing your thoughts. I has little curious on how to implement this in sql server.

So, I was checking the MSDN documentation and I have some questions based...

Thank you Steve.

Thank you Jeff and Steve.

Thanks Anthony

We captured...

my ps script code looks something like below :

function Out-DataTable

{

#.....

}

function Write-DataTable

{

#.....

}

Get-EventLog -ComputerName srv1 -LogName Application | select index,TimeGenerated,EntryType,Source,InstanceID,Message | Out-DataTable | Write-DataTable -ServerInstance srv1 -Database master -TableName EventViewer

Ken,

I tried including "Out-DataTable" as well as "Write-DataTable" functions code within my powershell script, still I am getting error.

https://gallery.technet.microsoft.com/scriptcenter/4208a159-a52e-4b99-83d4-8048468d29dd

https://gallery.technet.microsoft.com/scriptcenter/2fdeaf8d-b164-411c-9483-99413d6053ae

My observation is that, in Write-DataTable function , there is a positional...

Thank you Ken. I will check on it.

Thanks everyone for the help.

Answers inline please

few questions.

• • what is the size of db - logs and data sizes separate

2.3TB

• • is IFI enabled on the server

Yes

• This reply was modified 5 years, 5 months ago by Steve Jones - SSC Editor.

Thanks Neil. it works like a charm.

A follow up question, how does clearing of CACHE is related shrinking the database?