1. I have X4 Temdb Data files which matches to the actual cores (Not Hyper threaded).

2. Yes I have read that somewhere also yesterday during my hunt for some answers....

Neither can I but here we are.

When i was auditing the server i found the issue and engaged the programmers and

the explantion i got was "its connection pooling thats...

I have already and it further highlights that the coded applications are not behaving correctly pertaining to their connection management.

The idea behind connection pooling is that it re-using its already...

Hi Gail,

The log i am seeing is "security_error_ring_buffer_recorded".

pretty much i have drilled into the system_health section of management studio in sql 2012

and chose to "watch Live Data" and i see...

There are a lot of these entries which are happening and I am concerned if there is a problem or not given that the SQL Server Log's doesn't show any...

Hi DHeath,

The Type of replication I am doing is merge replication and I have a two hop setup where I have

Publisher->Publisher Subscriber(Republishing Server)->Subscriber

and I am also using Web Synchronization...

I agree with the post completely.

On our end, pertaining to Index maintenance, we have a scheduled job which run daily to persist query data from the Index Usage Stats DMV

etc...

FYI i have been monitoring the data on a hour to hour basis and 99.9% of the time all the data is OK but the trend

seems to be a few...

I would encourage you to get access to commvault. We have a similar situation in that systems manage all backup jobs etc through commvault but us SQL guys still have...

Ok that makes sense.

Thanks for your feedback and such a fast reply 🙂

"Why drop and recreate? So that you can do some large data loads? "

No large data load's , just purely from an index maint standpoint.

Ok thanks for your feedback