New answers tagged

2 votes

View memory usage by database on an SQL server

Memory usage has recently been spiking to 100% on the server, causing performance issues... How do you know Memory pressure is the source of your performance issues? It is normal, by design, for SQL ...
J.D.'s user avatar
  • 35.1k
0 votes

View memory usage by database on an SQL server

Is there any way to check memory usage by database To provide answer to this specific question - to check how much memory each database is currently using in the buffer pool (how much of database's ...
Aleksey Vitsko's user avatar
0 votes

MySQL memory usage is too high - OOM

5,000 connections is a LOT, there are a lot of different memory buffers allocated on a per connection basis. Just your max_connections * tmp_table_size is enough to overwhelm your server's memory if ...
Gordan Bobić's user avatar
0 votes

mysql memory usage keeps growing without visible reason

First thing to check is what the approximate theoretical maximum memory usage of your database is. As discussed in my MySQL tuning article, the equation you should be using to approximate maximum ...
Gordan Bobić's user avatar
7 votes
Accepted

SQL Server memory requirements

I'm afraid the memory pressure issues are a result of the server configured with not enough RAM memory? Is this assumption correct or are these problems created by something else? That's most likely ...
Sean Gallardy's user avatar

Top 50 recent answers are included