2022 Developer Survey is open! Take survey.

New answers tagged

0 votes
Accepted

SQLCONNECTIONPOOL growing very huge

So finally we applied permanent fix. I convinced my application team to update the JDBC drives to latest on application server. After that, the issue got disappeared. Now the sqlconnectionpool size is ...
user avatar
2 votes
Accepted

What is the reasoning behind allocating the OS 1GB for each 4GB of RAM?

I'd say ask the author, he's got quite a complicated formula for calculating Memory allocation, IMO. There's a bunch of rule of thumbs out there on how much Memory to leave the OS hosting a SQL Server ...
user avatar
  • 24.2k
0 votes

MySQL's maximum memory usage is dangerously high

Analysis of GLOBAL STATUS and VARIABLES: Observations: Version: 10.2.43-MariaDB-log 7.6 GB of RAM Uptime = 00:49:57; Please rerun SHOW GLOBAL STATUS after several hours. 153 QPS The More ...
user avatar
  • 68.2k
0 votes

MySQL's maximum memory usage is dangerously high

Rate Per Second = RPS Suggestions to consider for your my.cnf [mysqld] section novaterr.com innodb_buffer_pool_size=4G # from 128M to reduce innodb_buffer_reads RPS of 802 ...
user avatar
  • 1,599
1 vote

Whether `SQL Server: Memory Manager: Target Server Memory (KB)` is ideal amount of memory based on recent workload OR the max memory setting?

This answer assumes the system is not configured with LPIM and startup trace flag 834 - such a system plays by its own rules which are fairly unique. If [Max Server Memory] is set to a value SQL ...
user avatar
  • 1,158
0 votes

Whether `SQL Server: Memory Manager: Target Server Memory (KB)` is ideal amount of memory based on recent workload OR the max memory setting?

Answering your question Whether SQL Server: Memory Manager: Target Server Memory (KB) is ideal amount of memory based on recent workload OR the max memory setting? Target Server Memory is "The ...
user avatar
0 votes

SQLCONNECTIONPOOL growing very huge

In my experience it was a driver problem. Basically, some application is calling sp_prepare system procedure through an JDBC driver and do not call sp_unprepare. This seems to be a bug in the JDBC ...
user avatar
  • 3,367

Top 50 recent answers are included