Viewing 15 posts - 1 through 15 (of 48 total)
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...
November 7, 2019 at 4:48 pm
The client was unable to reuse a session with SPID XX, which...
November 27, 2018 at 7:47 am
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....
November 26, 2018 at 9:12 pm
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...
November 26, 2018 at 9:09 pm
Was this issue resolved?
May 30, 2018 at 12:54 pm
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.
March 28, 2018 at 1:02 pm
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...
February 24, 2018 at 6:54 am
Was this issue resolved?
September 14, 2017 at 7:40 pm
Do you have a resolution for this issue?
September 14, 2017 at 11:29 am
Do you have a resolution for this issue?
September 14, 2017 at 11:29 am
Yes, I am aware of the setting being persistent on SQL2016. I would like to know for versions older than 2016.
June 22, 2017 at 8:21 am
How can we make "ApplicationIntent = ReadOnly " persistent in SSMS?
June 22, 2017 at 6:52 am
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...
February 2, 2017 at 6:54 am
October 7, 2015 at 8:01 am
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...
October 7, 2015 at 7:50 am
Viewing 15 posts - 1 through 15 (of 48 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy