Question : How do I determine the right value for innodb_sync_array_size in MySQL? We have version 5.7 deployed on AWS […]
Tag: waits
OLEDB Wait Type and Functions
Question : Is there any relationship between the OLEDB Wait Type and functions? Trying to troubleshoot why I would have […]
Linking Waits to a process/statement
Question : I’m starting to take on more of a DBA role and trying to get tooled up with scripts […]
Strangely high writes per second
Question : I’m experiencing some extremely strange behavior on one of our OLTP Servers. Just to provide a bit of […]
SQL Server: dm_exec_requests.wait_time vs. dm_exec_sessions.last_request_end_time
Question : We have a third-party Microsoft Access application that uses SQL Server 2012 as its data store. It is […]
Is it safe to cancel a PostgreSQL ALTER TABLE query that is waiting on a lock?
Question : We started an ALTER TABLE query hours ago and only recently realized (via pg_stat_activity) that it is waiting […]
Confused about sys.dm_io_virtual_file_stats num_of_reads/writes column
Question : I’m trying to use the sys.dm_io_virtual_file_stats DMF to generate so IO wait information across a number of my […]
Increased waits during checkpoint after upgrading to better storage
Question : When we migrated from an older all flash array, to a newer all flash array (different, but well […]
Lots of short term blockings on SQL Server 2008-R2 database
Question : Seeking experts advise on short term blocking which we are seeing for almost a week now. DB is […]
Shared memory connection experiencing network wait type
Question : I have a poorly written application running a SELECT *, resulting in a 2MB result set every few […]