In the drop down in the certificate we have selected the available certificate in the configuration manager

Copied the same certificate to W1 as well, now both servers show same 2 certificates on both servers.

Http load balancer is working , but I am getting the error when I try to access the secured site https://, do you still think it could be...

Load Balancer is done through F5 and it is working as I am able to get the http:\\ URL when either of the reporting services are stopped.

Only when I try...

Because it is load balancer the URL should be accessible when either of the service\ sever is online.

Both servers have TLS 1.2 only enabled

I was not able to run the command.

But, I have been checking now and then and do not see any other databases using tempdb. Only think I can say is...

I thought so too.

But, do you know why it would fill up tempdb?

It writes to Windows Event and SQL Service account does have access.

Sorry the confusion.

So, I have to modify SQL Agent job to execute :

EXECUTE dbo.IndexOptimize

@databases = 'USER_DATABASES',

@FragmentationLow = NULL,

@FragmentationMedium = NULL,

@FragmentationHigh = NULL,

@UpdateStatistics = 'ALL',

@LogToTable = 'Y'

INSTEAD of

EXECUTE dbo.IndexOptimize...

This is the link used for updating statistics

https://www.brentozar.com/archive/2016/04/updating-statistics-ola-hallengrens-scripts/

Thanks.

Thank you so much for quick response, appreciate it.

I used sp_spaceused to find size of index and it is 40 GB and free space on the DB is around 19 GB.

Will adding additional 40 GB or more to...

Thank you for the reply.

Right now, allocated space for the mdf file is 185746.88 MB and free space is 19268 MB(10%).

So, how much of free space do I need? and...

I have attached the extended event snippet.

I am using the script from https://ola.hallengren.com  and executing the script below from SQL Agent:

EXECUTE dbo.IndexOptimize @databases = 'USER_DATABASES',

@FragmentationLow = NULL,

@FragmentationMedium...

It is showing in extended file events and also from script which shows what is causing database growth.