Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
0 votes
0 answers
98 views

SQL Server - Measuring impact of CTFP change....at server level

I have a SQL Server 2017 server and CTFP has been set to 5 since it was set up. I'm considering changing it. I'm comfortable in monitoring the impact of this change at the individual query level - ...
FrugalShaun's user avatar
0 votes
1 answer
87 views

MySQL server upgrade, how to adapt variables?

I am about to upgrade my MySQL server because I have currently used it mainly with a couple of people in the development stage. Before we launch, however, we would like more capacity to avoid the ...
PennyWise's user avatar
  • 101
0 votes
1 answer
2k views

Why is turning on Event Scheduler Maxing my CPU?

I have search the web for the last week trying to figure this out. I have exported my tables and events, re-installed the lastest MySQL and imported. I have tried checking individual procedures. My ...
DDeathlonger's user avatar
3 votes
1 answer
4k views

Is it bad to assign specific processors to SQL Server 2008 R2 cluster instances?

I have a SQL Server 2008 R2 failover cluster with a passive node and an active node. The servers are physically identical. I have two instances of SQL Server, one set to use all the CPUs in the ...
influent's user avatar
  • 339