The tag has no usage guidance.

learn more… | top users | synonyms

5
votes
1answer
150 views

Microsoft SQL Server 2012 Mirrors Go Into Disconnected

I have some Microsoft SQL server 2012 mirrors, without a witness in asynchronous mode, that are sporadically going into disconnected. I am running SQL Server 2012 11.0.5058. Looking at the logs on ...
4
votes
1answer
295 views

Is it a waste to set innodb_buffer_pool_instances greater than the # of CPUs?

I set the innodb_buffer_pool_size to 20GB on a server with 12 CPU cores. My full database is 11gb, however most of it is archived tables that are almost never used. The total queried data is around 3 ...
2
votes
0answers
304 views

Empty Space in buffer pool

I was doing some reading and came across this article from Paul Randal: http://www.sqlskills.com/blogs/paul/performance-issues-from-wasted-buffer-pool-memory/ Using the queries from that article, I ...
2
votes
0answers
261 views

tempdb objects creator wanted, bufferpool issue caused by tempdb objects

I have a number of tables in tempdb named like #A0030B77 #A01D908C #A06D1FCB #A0F72FB0 #A1614404 #A1EB53E9 #A205D8FE #A255683D How (if) can I get spid of the process which created them? These ...
1
vote
0answers
69 views

Does “CREATE INDEX WITH DROP_EXISTING” use the bufferpool for the recreated index?

We have recreate our 4TB clustered index in ouor SQL Server. Even thought we have 1.5TB of memory we still run into the following error message: "Msg 802, Level 17, State 2, Line 30 There is ...
1
vote
0answers
25 views

AlwaysOn AG Live Migration

A couple of thoughts on AlwaysOn AG migrations: Is there a reason why Microsoft didn't implement similar technology to Hyper-V Live Migration to AlwaysOn AGs so that the buffer pool and cache are ...
0
votes
0answers
41 views

How to minimize the InnoDB page evictions in a MySQL full in-memory db?

I have a MySQL (Percona 5.6) database, on a server which has enough memory to contain the entire dataset. Specifically: Total memory allocated 98901688320 Innodb_buffer_pool_bytes_data 79246950400 ...
0
votes
0answers
135 views

Should innodb_buffer_pool_size be much larger than the innodb_buffer_pool_bytes_data?

Our old server had 32GB total RAM, 18GB allocated to innodb_buffer_pool_size. It also had 10GB for the php_memory_limit. The new one had 16GB RAM, 9GB for innodb, 5GB for php. The same application ...