Timeline for SQL Server 2008 R2 Express high insert slowdown possibly due to PAGEIOLATCH_SH
Current License: CC BY-SA 3.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 22, 2012 at 15:31 | comment | added | dsum | I think statistics is on, I checked the connection. The are closed, but there are quite a number of them, something like 16 connections. I thought SQLServer can handle quite a number of connections, but it may be causing many page read for some reason. | |
| Mar 22, 2012 at 11:27 | history | answered | SqlACID | CC BY-SA 3.0 |