Skip to main content

New answers tagged

-1 votes

Billing Model in PieCloudDB

In addition to the pay-as-you-go billing model, PieCloudDB also supports annual and monthly subscription and will support automatic renewal in the latest product version. Currently, subscription ...
PDB's user avatar
  • 1
1 vote

Making mysql write more to ram and less to SSD

Given that the data is bigger than ram... Worry about "locality if reference" Shrink datatypes (to make tables smaller, hence write sizes) Improve indexes (to decrease disk reads and writes)...
Rick James's user avatar
  • 78.6k
1 vote

Making mysql write more to ram and less to SSD

You could totally eliminate writes if you set read_only=ON and innodb_read_only=ON. You could even operate the MySQL instance on non-writable media, like a CDROM disk. But I assume you want to allow ...
Bill Karwin's user avatar
  • 15.2k
5 votes
Accepted

getting the memory settings for all instances in a server

You can use DbaTools' excellent Powershell script library for this. $instances = Find-DbaInstance -ScanType All -ComputerName localhost; $instances | Get-DbaSpConfigure -Name "min server memory ...
Charlieface's user avatar
  • 13.7k
1 vote

getting the memory settings for all instances in a server

one way I have found is to add a group in the registered servers for example SERVER_T007, then inside that group add both instances - in my case: server_t007 server_t007\sql2016 then run a query ...
Marcello Miorelli's user avatar

Top 50 recent answers are included