Gail,

I am seeing high "Compile: waits on a stored procedure causing other processed not to execute the same stored procedure. This is leading to blocking on the database and is...

Receiving this error on SQL 2012 Always on. Any possible resolution?

The client was unable to reuse a session with SPID XX, which had been reset for connection pooling....

Receiving below error. Has anyone come across this error?

The client was unable to reuse a session with SPID XX, which had been reset for connection pooling. The failure...

Was this issue resolved?

Below query will give the rows sampled during update stats.

SELECT * FROM sys.dm_db_stats_properties (object_id('TableName'), 1);

Default sampling size was 0.5 when Update Statistics was used.

Gianluca Sartori / Grant Fritchey,
There is a daily sp_update stats (on db which is 4TB) that is causing high CPU. To reduce the CPU, it is requiring us to...

Was this issue resolved?

Do you have a resolution for this issue?

Do you have a resolution for this issue?

Yes, I am aware of the setting being persistent on SQL2016. I would like to know for versions older than 2016.

How can we make "ApplicationIntent = ReadOnly " persistent in SSMS?

This setting does facilitate load balancing the resources on a traditional active-active cluster, hosting multiple SQL instances. After host patching you don't want to find out that all the instances...

https://support.microsoft.com/en-us/kb/2699720

Cause: This issue occurs because of a problem in the [SSISDB].[catalog].[create_execution] stored procedure. When multiple calls are made to the [SSISDB].[catalog].[create_execution] stored procedure at the same time, the requested locks...